Trigger.NotForReplication Property

Gets or sets a Boolean property value that specifies whether the trigger is included in replication operations.

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.Deploy)> _
Public Property NotForReplication As Boolean 
    Get 
    Set
'Usage
Dim instance As Trigger 
Dim value As Boolean 

value = instance.NotForReplication

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

Property Value

Type: System.Boolean
A Boolean value that specifies whether the trigger is included in replication or not.If True, the trigger is not included in replication.If False (default), the trigger is included in replication.

Examples

Creating, Altering, and Removing Triggers

See Also

Reference

Trigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DML Triggers

CREATE TRIGGER (Transact-SQL)