Configuration.ServerTriggerRecursionEnabled Property
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Use the server trigger recursion option to specify whether to allow server-level triggers to fire recursively. When this option is set to 1 (ON), server-level triggers will be allowed to fire recursively. When set to 0 (OFF), server-level triggers cannot be fired recursively. Only direct recursion is prevented when the server trigger recursion option is set to 0 (OFF). (To disable indirect recursion, set the nested triggers option to 0.) The default value for this option is 1 (ON).
C#
public Microsoft.SqlServer.Management.Smo.ConfigProperty ServerTriggerRecursionEnabled { get; }member this.ServerTriggerRecursionEnabled : Microsoft.SqlServer.Management.Smo.ConfigPropertyPublic ReadOnly Property ServerTriggerRecursionEnabled As ConfigProperty| Product | Versions |
|---|---|
| Microsoft.SqlServer.SqlManagementObjects | 150.18208.0, 160.2004021.0 |