This topic has not yet been rated - Rate this topic

DatabaseDdlTrigger.IsEnabled Property

SQL Server 2012

Gets or sets the Boolean property value that specifies whether the database data definition language (DDL) trigger is enabled.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool IsEnabled { get; set; }

Property Value

Type: System.Boolean
A Boolean property value that specifies whether the database DDL trigger is enabled.If True, the database DDL trigger is enabled. Otherwise, False (default).

Examples

Setting Properties

Reference

DatabaseDdlTrigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TRIGGER (Transact-SQL)

DDL Triggers

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD