chopeen, Newbie,

I developed a similar template which has saved me repeatedly, with one important extra:

begin tran

    if (@@trancount > 0) begin

        -- do something here

    end

    if (@@trancount > 0)...