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: Thursday, November 20, 2014 11:11 AM
Points: 58, Visits: 296
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:01 AM
Points: 14,029, Visits: 28,404
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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

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

Add to briefcase

Permissions Expand / Collapse