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?