SQLTeam.com | Weblogs | Forums

Execute multiple stored procedure in one Stored procedure


I have around 10 stored procedure call in one procedure.


execute usp_loadtable1

execute usp_loadtable2 ........loadtable10

I want to confirm even if one stored procedure fails all others are executed. should I give 'Go' after each execute


use try catch block or check the return code from each proc