CopyAllDatabaseTriggers Property

Transfer.CopyAllDatabaseTriggers Property

SQL Server 2008 R2

Gets or sets the Boolean property value that specifies whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

public bool CopyAllDatabaseTriggers { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether SQL Server database triggers are copied in the transfer operation.
If True, all SQL Server database triggers are copied from the source database to the target database. Otherwise, False (default).

Community Additions

ADD
Show:
© 2016 Microsoft