Freigeben über


Trigger.IsEnabled-Eigenschaft

Gets or sets the Boolean property that specifies whether the trigger is enabled.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property IsEnabled As Boolean 
    Get 
    Set
'Usage
Dim instance As Trigger 
Dim value As Boolean 

value = instance.IsEnabled

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

Eigenschaftswert

Typ: System.Boolean
A Boolean value that specifies whether the trigger is enabled.If True, the trigger is enabled.If False (default), the trigger is not enabled.

Beispiele

Erstellen, Ändern und Löschen von Trigger

Siehe auch

Verweis

Trigger Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

DML-Trigger

CREATE TRIGGER (Transact-SQL)