How to find in what Trigger/StoredProc/Function the error occurs
Posted on 2004-09-22
I'm executing a stored procedure. The code in the procedure invokes a lot of triggers that each of them start other stored procedures, use functions, ....
When looking at the messages i'm getting the typical lines of xxx records Processed, but suddenly also an error
(14 row(s) affected)
(37 row(s) affected)
Server: Msg 298, Level 16, State 1, Line 311
The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.
I know whet the error means but i don't know in what trigger/.... it occurs so i have no clue on wich table i'm getting the problem.