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

1. SQL Server / T-SQL Tutorial
2. Transaction
3. Save points

Syntax for the SAVE TRANSACTION Statement

SAVE TRAN [ SACTION ] { savepoint_name | @savepoint_variable }