|
nigelrivett
Flowing Fount of Yak Knowledge
United Kingdom
3328 Posts |
 Posted - 02/14/2013 : 09:37:58
|
see this
http://www.nigelrivett.net/Products/DWBuilder/TraceTable.html
Just add a try - catch block to trap erors.
This then logs the error and re-raises it.
This will again be trapped and logged by a calling sp.
The good thing is that as long as the handling is in a higher level sp then all calling sps will have their errors trapped - I prefer to add it to all sps though so you get the stack.
==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
How to add error handling for stored procedures?
