TransferSqlServerObjectsTask.CopyTriggers Property

Article
12/03/2008

Gets or sets a Boolean indicating whether triggers are included in the transfer from the source to the target database.

Namespace: Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Assembly: Microsoft.SqlServer.TransferSqlServerObjectsTask (in microsoft.sqlserver.transfersqlserverobjectstask.dll)

Syntax

'Declaration
Public Property CopyTriggers As Boolean

public bool CopyTriggers { get; set; }

public:
virtual property bool CopyTriggers {
    bool get () sealed;
    void set (bool value) sealed;
}

/** @property */
public final boolean get_CopyTriggers ()

/** @property */
public final void set_CopyTriggers (boolean value)

public final function get CopyTriggers () : boolean

public final function set CopyTriggers (value : boolean)

Property Value

true indicates that triggers are transferred from the source to the target database.

Remarks

The default value is true.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via