• Sometime ago I created a Query Analyzer template like this:

    BEGIN TRAN

    /* queries go here */

    -- ROLLBACK TRAN

    -- COMMIT TRAN

    --

    -- SELECT @@TRANCOUNT

    -- DBCC OPENTRAN

    If I make any ad hoc changes, I always use it.