Autocommit mode is the default transaction management mode of the Microsoft® SQL Server Database Engine. Every Transact-SQL statement is committed or rolled back when it completes. If a statement completes successfully, it is committed; if it encounters any error, it is rolled back. A connection to an instance of the Database Engine operates in autocommit mode whenever this default mode has not been overridden by either explicit or implicit transactions. Autocommit mode is also the default mode for ADO, OLE DB, ODBC, and DB-Library.
"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."