[thelist] interesting sql server problem...

Chris Blessing webguy at mail.rit.edu
Tue Oct 29 12:31:01 CST 2002

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

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...


Chris Blessing
webguy at mail.rit.edu

More information about the thelist mailing list