There is ALWAYS a transaction whenever any kind of data modification occurs. Each DML statement starts an implicit transaction. You can choose to enlist one or more DML statements in an explicit transaction (using BEGIN TRAN / ROLLBACK / COMMIT), but there is no way to turn off the implicit transaction. That's one of the many features in SQL Server that helps to ensure the ACID properties.