Nested transaction - SAVE vs BEGIN [TRAN] [Archive] - dBforums
As David Browne himself says, this is a good "pattern for a nestable, atomic
stored procedure that can be invoked whether or not the connection has
already started a transaction."
Nested transaction - SAVE vs BEGIN [TRAN] [Archive] - dBforums