• That's only true if you run in Implicit Transaction Mode (SET IMPLICIT_TRANSACTIONS ON).

    Otherwise you have to execute a BEGIN TRAN to start a transaction.