DistributorAvailable Property (SQL-DMO)

The DistributorAvailable property exposes the connected state of a replication Distributor.

Applies To

Syntax

object.DistributorAvailable

Part	Description
object	Expression that evaluates to an object in the Applies To list

Remarks

For Microsoft® SQL Server™, replication Publishers do not need to also distribute published data. One or more SQL Server installations may act as Distributors. If the Publisher data is not its own Distributor, it relies on a connection to an identified Distributor.

If True, the SQL Server installation can successfully connect to its identified Distributor.

If False, the SQL Server installation cannot successfully connect to its identified Distributor.

The property is always True for SQL Server installations that distribute their own publications.

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetDistributorAvailable(LPBOOL pbDistributorAvailable);