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

Transaction Rollbacks

The opposite of a commit is a rollback. A rollback reverses any changes made by a transaction that has not been committed. A rollback can occur in one of two ways: as an automatic rollback by SQL Server or as a manually programmed rollback. In many scenarios, such as restoring data or a client connection being interrupted during a transaction, SQL Server performs automatic rollback for you.

Automatic Rollbacks

If a transaction fails because of a severe or fatal error, such as a loss of network connection while the transaction is being run or a failure of the client application or server, SQL Server automatically rolls back the transaction. A rollback reverses all database modifications the transaction performed and frees up ...

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