Dear friends,

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

How are you using @@error? Can you provide an example?

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html