IMPLICIT_TRANSACTIONS should be enabled to ensure the transaction is secure. In case of any failure in middle will roll back the entire transaction.
SET IMPLICIT_TRANSACTIONS ON
SET IMPLICIT_TRANSACTIONS OFF
How to save a transaction only after it execute commit ? was last modified: October 1st, 2017 by