Jack,

Thanks for your explanation. This makes sense now. I didn't know that @@ERROR doesn't trap runtime errors and that the sproc would be terminated when a runtime error occurs.

Anyway, I...