[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