DatabaseDdlTrigger.NotForReplication Property

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

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

value = instance.NotForReplication

instance.NotForReplication = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool NotForReplication { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool NotForReplication {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
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 database DDL trigger is available for replication.If True, the database DDL trigger cannot be used by replication services. Otherwise, False (default).

Remarks

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

This property is not supported after SQL Server 2005.

Examples

Setting Properties

See Also

Reference

DatabaseDdlTrigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TRIGGER (Transact-SQL)

DDL Triggers