Nested Triggers

Triggers can cause other triggers to fire if the nested triggers option has been enabled with sp_configure. Triggers can fire themselves recursively if the recursive triggers database option has been enabled. The @@NESTLEVEL automatic variable returns 1 within a first-level trigger, 2 within one it causes to fire, 3 for any it causes to fire, and so forth.

Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The 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.