Database.RecursiveTriggersEnabled Database.RecursiveTriggersEnabled Database.RecursiveTriggersEnabled Property

Definition

Gets or sets a value that specifies whether recursive triggers are enabled on the database.

public:
 property bool RecursiveTriggersEnabled { bool get(); void set(bool value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Design)]
public bool RecursiveTriggersEnabled { get; set; }
Public Property RecursiveTriggersEnabled As Boolean
Property Value

A Boolean value that specifies whether recursive triggers are enabled on the database. If True, recursive triggers are enabled. If False (default), recursive triggers are not enabled.

Implements

Remarks

This property specifies whether a trigger called by another trigger is executed.

This option can also be changed by using the Transact-SQL ALTER DATABASE statement.

Applies to