AFTER Triggers
AFTER triggers fire after the firing statement has already taken place. You use these triggers to react to changes against the database server.
DML AFTER triggers can be created only on permanent tables. They cannot be created on views or temporary tables. You create such triggers on a specific table and for a specific DML statement or statement list, including INSERT, UPDATE, and DELETE.
If a constraint defined on a table rejects a modification, a trigger defined on that table will not fire.
AFTER triggers are fired per statement, not per row. Regardless of how many rows were affected by the firing statement (zero, one, or multiple), an AFTER trigger will fire only once.
You can create multiple AFTER triggers (both DML and DDL) on ...
Get Inside Microsoft® SQL Server™ 2005 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
