ReplicationServer.DistributionPublishers Property

Article
12/03/2008

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

public DistributionPublisherCollection DistributionPublishers { get; }

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

/** @property */
public DistributionPublisherCollection get_DistributionPublishers ()

public function get DistributionPublishers () : DistributionPublisherCollection

Property Value

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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Share via