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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
