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 |
|
Pete32
Starting Member
4 Posts |
 Posted - 2007-03-30 : 09:48:02
|
| We recently switched over from SQL7 to SQL2000 and a new error has come up. The statements below raise the "Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer." error on SQL2000 but not SQL7. declare @row integerset @row = nullset rowcount @rowI understand that this error should occur, but why doesn't it raise an error on our SQL7 server. I'm guessing this has to do with the configuration options, but I can't figure which one. Please help. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Set Rowcount error on SQL7 but not SQL2000