Ask SQLTeam Question
Posted - 12/06/2000 : 09:31:01
| Kyle writes "The company I work for has two SQL servers running SQL 7.0. It is sometimes necessary to use the SQL function NEWID() to get a string of random hexadecimal numbers for one of our applications. On one of the servers, successive calls to the NEWID() function result in completely different output, shown below. However, on the other server, successive calls result in output that is almost exactly the same. Any idea what's going on?
First Server: SQL 7.0, Windows 2000
Second Server: SQL 7.0, NT 4.0 SP 5