DistributorAvailable Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

object.DistributorAvailable

Parts

  • object
    An 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 can 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.

Applies To: