IDatabaseOptions.RecursiveTriggersEnabled IDatabaseOptions.RecursiveTriggersEnabled IDatabaseOptions.RecursiveTriggersEnabled Property

Definition

Gets or sets the Boolean 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.DisplayDescriptionKey("Database_RecursiveTriggersEnabledDesc")]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayNameKey("Database_RecursiveTriggersEnabledName")]
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.

Examples

How to Get and Set a Property in Visual Basic .NET

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