This topic has not yet been rated - Rate this topic

DatabaseDdlTrigger.NotForReplication Property

SQL Server 2012

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

'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

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