nested triggers Option

Use the nested triggers option to control whether a trigger can cascade (perform an action that initiates another trigger that initiates another trigger, and so on). When nested triggers is set to 0, triggers cannot cascade. When nested triggers is set to 1 (the default), triggers can cascade to as many as 32 levels.

The setting takes effect immediately (without a server stop and restart).

To set the nested triggers option

Enterprise Manager

Transact-SQL

SQL-DMO

See Also

Using Nested Triggers

RECONFIGURE

Setting Configuration Options

sp_configure