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 before the SAVEPOINT are not undone; they are still pending.

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.

There must have been a corresponding SAVEPOINT within the current transaction.

None.

• BEGIN TRANSACTION statement [T-SQL]
• COMMIT statement
• RELEASE SAVEPOINT statement
• ROLLBACK statement
• SAVEPOINT statement
• Savepoints within transactions