![ROLLBACK TRANSACTION statement [T-SQL]](arrow-right.gif){kind=icon}
Cancels any changes made since a SAVEPOINT.
ROLLBACK TO SAVEPOINT [ savepoint-name ]
The ROLLBACK TO SAVEPOINT statement will undo any changes that have been made since the SAVEPOINT was established. Changes made prior to the SAVEPOINT are not undone; they are still pending. For a description of savepoints, see Chapter 1, “Using Procedures and Batches” in the System Administration Guide: Volume 2.
The savepoint-name is an identifier that was specified on a SAVEPOINT statement within the current transaction. If savepoint-name is omitted, the most recent savepoint is used. Any savepoints since the named savepoint are automatically released.
None
Sybase Savepoints are not supported by Adaptive Server Enterprise. To implement similar features in an Adaptive Server Enterprise-compatible manner, you can use nested transactions.
There must have been a corresponding SAVEPOINT within the current transaction.
