[thelist] interesting sql server problem...

[Chris Blessing]

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