Distributor Property

Replication Programming

Replication Programming

Distributor Property

The Distributor property sets or returns the name of the Distributor server.

Applies To

AlternateSyncPartner Object

SQLDistribution Object

SQLMerge Object

SQLSnapshot Object

Syntax

object.Distributor [= name]

Part Description
object Expression that evaluates to an object in the Applies To list.
name Name of the Distributor used by the Publisher.
Remarks

Distributor is a required property for the SQLSnapshot object but optional for the other controls.

The Distributor is the instance of Microsoft® SQL Server™ on which the snapshots are stored by default, and on which replication history and statistics are logged. For the SQL Distribution control, it is also the location of the store-and-forward database that contains the replicated transactions.

If the DistributorNetwork and DistributorAddress properties are specified, they will be used instead of the Distributor property when connecting to the Distributor.

If Distributor connection properties are not specified, it is assumed the Publisher and Distributor are on the same instance of SQL Server, and Publisher connection properties will be used when connecting to the Distributor.

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT Distributor(BSTR pVal);

HRESULT Distributor(BSTR* pVal);

See Also

DistributorAddress Property

DistributorNetwork Property