SQLTeam.com | Weblogs | Forums

Execute multiple stored procedure in one Stored procedure

Hi,

I have around 10 stored procedure call in one procedure.

like

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

thanks

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