Thanks for the reply. I can understand the need to move to Try..Catch instead of @@ERROR. How ever, I am NOT able to understand what you mean by the below statement.

"@@ERROR really doesn't catch errors, it reports them"

When I tested the SP, control does NOT even come down to @@ERROR (error handling) statement when there was an error in one of the update statement. Then how we can say that @@ERROR statement can report the error?

Could you please explain bit more?

Thanks,

Suresh