allow nested triggers controls the use of nested triggers.
|
Summary Information |
|
|---|---|
|
Default value |
1 (on) |
|
Valid values |
0 (off), 1 (on) |
|
Status |
Static |
|
Display level |
Intermediate |
|
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.