[thelist] interesting sql server problem...

Scott pippen at bigpond.net.au
Tue Oct 29 16:30:00 CST 2002


Basically NewID() in SQL7 is buggy - however it works
fine in SQL2k.

http://www.sqlteam.com/item.asp?ItemID=8747

----- Original Message -----
From: "Chris Blessing" <webguy at mail.rit.edu>
To: <thelist at lists.evolt.org>
Sent: Wednesday, October 30, 2002 4:35 AM
Subject: [thelist] interesting sql server problem...


: Hi all, once again-
:
: I've run into a snag with SQL Server 7.  You know that handy function
: newid()?  Well I'm using it to generate random numbers to create random
: character strings... good times.
:
: So we've got 2 servers here.  One development unit, which is the one acting
: up, and one production unit which is functioning as expected.  Using a
: simple while() loop, I'm generating the SAME unique identifier using newid()
: on the dev box, while the production box is generating unique unique
: identifiers on every iteration of the loop.  That's how it's supposed to
: work.
:
: Anyone run into a problem like this?  I'm suspecting it's a global variable
: problem or something within the server config.  I can't seem to successfully
: google this one...
:
: TIA!
:
: Chris Blessing
: webguy at mail.rit.edu
: http://www.330i.net
:
: --
: For unsubscribe and other options, including
: the Tip Harvester and archive of thelist go to:
: http://lists.evolt.org Workers of the Web, evolt !
:





More information about the thelist mailing list