DistributorAvailable Property

SQL-DMO

SQL-DMO

DistributorAvailable Property

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

Applies To
Distributor Object
Syntax

object.DistributorAvailable

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetDistributorAvailable(LPBOOL pbDistributorAvailable);

Remarks

For Microsoft® SQL Server™, replication Publishers are not required to also distribute published data. One or more instances of SQL Server 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 instance of SQL Server can successfully connect to its identified Distributor.

If FALSE, the instance of SQL Server cannot successfully connect to its identified Distributor.

The property is always TRUE for instances of SQL Server that distribute their own publications.