>>Not really.
>>value in @@Error changes after the execution of each statement. So if the first statement returned and error, and the last one returned ok, then @@error is ok. So after each statement you need to check @@error and copy its value into your own var.
>
>Now you known because i doesn't suggest this.
>On SQL 2005 TRY/CATCH fixes this
Yeah I have heard that SQL2005 has try/catch, but Iwant to be able to support both SQL2000 and SQL2005. This might change in a few years.
Semper ubi sub ubi.