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 - 2002-09-25 : 19:19:21
|
| al writes "Long day.........found the stuff on NEWID for generating random rows in same batch. fantastic, cause RAND is major pain. went to work, did it up on my dev box (SQL2000) local dc, GREAT. then tried it on our network SQL7 db............no sutch luk....went to '7's booksonline, and newid looks the same there as in the 2000 edition. hmmmmmmmmmmmmm.what am i missing here.thanks.aledsrentageek to dod" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-09-25 : 19:19:21
|
| The operating system needs to be Windows 2000 not NT4 for NEWID() to generate random results. Is the OS NT4? |
 |
|
|
lambertal
Starting Member
3 Posts |
Posted - 2002-09-26 : 11:37:49
|
quote:
The operating system needs to be Windows 2000 not NT4 for NEWID() to generate random results. Is the OS NT4?
OK,,thanks.The OS on the remote SQL7 box (does not work) is NT4, OS on local dev box (works with local db) is NT5(2000).So, have i got it right? NEWID needs an OS of 2000 on THE BOX HOSTING THE DB!!YES??thanks, al |
|
|
|
|
|
|
NEWID()??