-
@@Error code in SQL 2000 - 7.0 Compatible Mode
We have an existing stored procedure that uses the @@error code.
for every Delete being performed, @@error is used to caputre any errors and then used in the RAISEERROR statement.
It worked in SQL Server 7.0., but it is not working in SQL 2000 even when the datbase is in 7.0 compatible mode.
I rewrote the procedure to use a local variable that is set = to the global variable @@error and then I used the local variable in the RAISEERROR statement.
Shouldn't the original code work in the 7.0 compatible mode?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|