SnapshotGenerationAgent.MaxBcpThreads Property

Article
12/03/2008

Gets or sets the number of bulk copy operations that can be performed in parallel.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Replication (in microsoft.sqlserver.replication.dll)

Syntax

'Declaration
Public Property MaxBcpThreads As Integer

public int MaxBcpThreads { get; set; }

public:
virtual property int MaxBcpThreads {
    int get () sealed;
    void set (int value) sealed;
}

/** @property */
public final int get_MaxBcpThreads ()

/** @property */
public final void set_MaxBcpThreads (int value)

public final function get MaxBcpThreads () : int

public final function set MaxBcpThreads (value : int)

Property Value

An Int32 value that represents the number of parallel threads.

Remarks

The maximum number of threads and ODBC connections that exist simultaneously is the lesser of the value of MaxBcpThreads or the number of bulk copy requests that appear in the synchronization transaction in the distribution database.

The MaxBcpThreads property must have a value greater than 0 and has no hard-coded upper limit.

The default value of MaxBcpThreads is 1.

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