ROLLBACK WORK (T-SQL)

Rolls back a user-specified transaction to the beginning of a transaction.

Syntax

ROLLBACK [WORK]

Remarks

This statement functions identically to ROLLBACK TRANSACTION except that ROLLBACK TRANSACTION accepts a user-defined transaction name. With or without specifying the optional WORK keyword, this ROLLBACK syntax is SQL-92-compatible.

When nesting transactions, ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement and decrements the @@TRANCOUNT system function to 0.

Permissions

ROLLBACK WORK permissions default to any valid user.

See Also
BEGIN DISTRIBUTED TRANSACTION ROLLBACK TRANSACTION
BEGIN TRANSACTION SAVE TRANSACTION
COMMIT TRANSACTION Transactions
COMMIT WORK  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.