Need help to trap errors
I have created a Stored Procedure in sql server2000.
I found that the @@error is unable to catch errors occured while assigning a value to a local variable with set operator.
Is there any other way out to catch such errors.
thanks in anticipation