lnardozi 61862 (10/15/2013)
Without them, the transaction is left open if an error occurs during processing.
Unless XACT_ABORT is on.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability