Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-06 : 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
BE1CFA33-76EB-481B-8252-18F247624C5F
6A3321CF-A237-469F-8EE2-936E7E9770AE
5F326529-2790-4116-9D22-45BCD5CE9792
295E2293-68B5-44CA-BCFB-236959ABEE08
Second Server: SQL 7.0, NT 4.0 SP 5
C9AA6401-BF0E-11D4-9DAA-00805F0D4DB9
C9AA6402-BF0E-11D4-9DAA-00805F0D4DB9
C9AA6403-BF0E-11D4-9DAA-00805F0D4DB9
C9AA6404-BF0E-11D4-9DAA-00805F0D4DB9" |
|
|
|
|
|
NEWID()