• Article

ReplicationServer.DistributionPublishers Property

Gets the Publishers that use the currently connected instance of Microsoft SQL Server as a Distributor.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public ReadOnly Property DistributionPublishers As DistributionPublisherCollection
    Get
'Usage
Dim instance As ReplicationServer
Dim value As DistributionPublisherCollection

value = instance.DistributionPublishers

public DistributionPublisherCollection DistributionPublishers { get; }

public:
property DistributionPublisherCollection^ DistributionPublishers {
    DistributionPublisherCollection^ get ();
}

member DistributionPublishers : DistributionPublisherCollection

function get DistributionPublishers () : DistributionPublisherCollection

Property Value

Type: Microsoft.SqlServer.Replication.DistributionPublisherCollection
A DistributionPublisherCollection object that represents all the Publishers using the replication server as a Distributor.

Remarks

A DistributionPublisher object in the returned DistributionPublisherCollection can be accessed using either an integer or a string indexer.

The DistributionServer property is equivalent to the sp_helpdistpublisher (Transact-SQL) stored procedure.

The DistributionPublishers property can be retrieved by members of the sysadmin fixed server role for any Publisher using the local server as a Distributor; members of the db_owner fixed database role or the replmonitor role in a distribution database for any Publisher using the Distributor; and users in the publication access list (PAL) for any publication serviced by the Distributor.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.