Share via

  • Article

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.