Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

ROLLBACK TRIGGER statement

Use this statement to undo any changes made in a trigger.

ROLLBACK TRIGGER [ WITH raiserror-statement ]

The ROLLBACK TRIGGER statement rolls back the work done in a trigger, including the data modification that caused the trigger to fire.

Optionally, a RAISERROR statement can be issued. If a RAISERROR statement is issued, an error is returned to the application. If no RAISERROR statement is issued, no error is returned.

If a ROLLBACK TRIGGER statement is used within a nested trigger and without a RAISERROR statement, only the innermost trigger and the statement which caused it to fire are undone.

None.

None

• CREATE TRIGGER statement
• ROLLBACK statement
• ROLLBACK TO SAVEPOINT statement
• RAISERROR statement [T-SQL]

• SQL/2003    Transact-SQL extension.