This topic has not yet been rated - Rate this topic

DatabaseDdlTrigger.NotForReplication Property

SQL Server 2008 R2

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

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool NotForReplication { get; set; }

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

Reference

DatabaseDdlTrigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TRIGGER (Transact-SQL)

DDL Triggers

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD