• Instead , why cant you use SET XACT_ABORT ON in both the SP and remove all explicit transaction handling

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)