O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required