Nesting Triggers
A trigger can be defined to modify a table, which in turn can have a trigger defined to modify another table, and so on. In this case, triggers force the execution of other triggers, and the execution stops when the last action does not fire any more triggers.
Because triggers are a specialized form of stored procedures, you can nest trigger execution up to 32 levels. Triggers, stored procedures, scalar user-defined functions, and multistatement table-valued functions share this limit. If the execution of a sequence of nested triggers requires more than 32 levels, the execution is aborted, the transaction is rolled back, and the execution of the batch is cancelled.
Nested triggers are enabled by default. You can change this ...
Get Microsoft® SQL Server™ 2000 Programming by Example 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.
