allow nested triggers

allow nested triggers controls the use of nested triggers.

Summary Information

Default value

1 (on)

Valid values

0 (off), 1 (on)



Display level


Required role

System administrator

Configuration group

SQL Server Administration

When the value is set to 1, data modifications made by triggers can fire other triggers. Set allow nested triggers to 0 to disable nested triggers. A set option, self_recursion, controls whether the modifications made by a trigger can cause that trigger to fire again.

Note: The multiple triggers feature does not change the behavior of the allow nested triggers configuration parameter.