You could add some logging to the procedure, for example, inserting into a log table, or using the xp_logevent procedure.
If you are using explicit transactions, you might want to log to a table variable, and insert to an actual database table from it after rolling back your transaction.
————————————
Odds are you are adding numbers up, and that the value is larger than your numeric datatype allows for.
Discuss This Question: