I have a stored procedure using SQL Express that update a table using data from another table.
All is well except that from time to time the source table might have data that causes an error. I would like to add some code to the stored procedure that will catch the error, output the details to a text file then continue with the procedure.
How do I do this?
April 23, 2009 1:28 AM
April 26, 2009 8:00 PM