ServerDdlTrigger.IsEnabled Property

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

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property IsEnabled As Boolean 
    Get 
    Set
'Usage
Dim instance As ServerDdlTrigger 
Dim value As Boolean 

value = instance.IsEnabled

instance.IsEnabled = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool IsEnabled { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool IsEnabled {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member IsEnabled : bool with get, set
function get IsEnabled () : boolean 
function set IsEnabled (value : boolean)

Property Value

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

Examples

Creating, Altering, and Removing Triggers

See Also

Reference

ServerDdlTrigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DDL Triggers

CREATE TRIGGER (Transact-SQL)