Rajesh, thanks for the sample code.  It was enlightnening.  SQL Server should not just exit the procedure because of the 'string in an integer col' error.  The statement should fail &...

Thanks for the suggestions.  Unfortunately, the SP is called by a 3rd party application that I have no control over.  I do not know what sort of error handling it...

Thanks for the suggestions.  It is not reproducable & appears to be random.

It is a good suggestion to add the @Name value to my debug table before the updates but...