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
Author
Message
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: Monday, August 31, 2015 11:37 AM
Points: 58, Visits: 321
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:53 AM
Points: 15,752, Visits: 30,000
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 Query Performance Tuning
and
SQL Server Execution Plans

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

Add to briefcase

Permissions Expand / Collapse