How to trace procedure errors efficiently in sql2008
I have a stired procedure which have written very long and its also use to execute another procedures within a procedure. now this procedure doesn't seems work fine and I need to trace at which execution the procedure failed to run.
This procedure define to be run on sql jobs, but nothing were written when I try to enable the error log in sql jobs.
any best way to find where out the procedure failed within the job ?