SAVEPOINT [ savepoint-name ]

Establish a savepoint within the current transaction. The savepoint-name is an identifier that can be used in a RELEASE SAVEPOINT or ROLLBACK TO SAVEPOINT statement. All savepoints are automatically released when a transaction ends.

Savepoints that are established while a trigger or atomic compound statement is executing are automatically released when the atomic operation ends.

You cannot modify data in a proxy table from within a savepoint.

None.

None.

• RELEASE SAVEPOINT statement
• ROLLBACK TO SAVEPOINT statement
• SAVE TRANSACTION statement [T-SQL]
• Savepoints within transactions