The savepoint has meaning only inside a nested transaction. : Save points « Transaction « SQL Server / T-SQL Tutorial






Syntax for the SAVE TRANSACTION Statement

SAVE TRAN [ SACTION ] { savepoint_name | @savepoint_variable }
23.4.Save points
23.4.1.The savepoint has meaning only inside a nested transaction.
23.4.2.A transaction with two save points