Get column name of error `Arithmetic overflow error converting numeric to data type varchar.`

Question

I have a stored procedure; when I execute it, I get an error

Arithmetic overflow error converting numeric to data type varchar

Is there is way to find the column that caused this issue? I have the T-SQL. Checking columns one by one is very tedious for us because we have lots of columns (legacy system).

Answer 1

There are many options to address and prevent the error, based on the prodedure's T-SQL, but the answer to your question is "No". MS Does not make the offending column information available.

HTH, Sean