Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Stored Procedure Development Query Expand / Collapse
Posted Wednesday, July 2, 2008 4:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 18, 2013 11:59 AM
Points: 58, Visits: 290
I have one Main Stored Procedure.

I will be executing multiple stored procedure one by one. I would like to continue processing even in case one of the procedure was aborted due to Error.

How can I achieve this objective?

Post #527140
Posted Wednesday, July 2, 2008 6:23 AM



Group: General Forum Members
Last Login: Yesterday @ 5:46 AM
Points: 13,752, Visits: 28,148
It depends on the severity of the error. Higher severity errors cause a disconnect of the offending process. Those cannot be trapped.

For the other procedures, in SQL Server 2005, you can use TRY/CATCH constructs to get the job done. This is an introduction to the topic, but there's a lot more to learn.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #527231
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse