Microsoft® SQL Server™ 2005 Administrator's Companion

Committing Transactions

Now that you understand the properties of a valid transaction, let’s look at the mechanisms SQL Server provides to manage transactions with both the default SQL Server behavior and via programmable transaction management. The key to transactions is the commit process.

Committing transactions—in essence, committing the data changes made by transactions—is an integral part of data integrity, locking, and consistency. A commit is an operation that conceptually saves all changes to the database made since the start of a transaction. A commit guarantees that all of the transaction’s modifications, first written to the buffer cache in memory, will be permanent in the database. When a transaction is committed, it means any changed ...