title: IMPLICIT TRANSACTIONS ON/OFF and BEGIN /COMMIT Transaction
body: <p>I believe the default setting is for DML statements to be automatically committed (default is IMPLICIT TRANSACTIONS ON) but if I need to perform a BEGIN/COMMIT Transaction, does the IMPLICIT TRANSACTION setting automatically turn OFF within that BEGIN/COMMIT transaction?</p>