>>>You can also check @@error.
>>
>>Thanks for the idea. I would assume that it is a good practice to check @@ERROR before doing a COMMIT TRANSACTION also. What do you think?
>
>You've to check it after each statement because it gets reset the same way as @@ROWCOUNT

Thanks for the heads-up.

Einar