O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required