DistributionPublisher.RegisteredSubscribers Property

Gets the Subscribers that are subscribed to publications at the Publisher.

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

Syntax

'Declaration
Public ReadOnly Property RegisteredSubscribers As RegisteredSubscriberCollection 
    Get
'Usage
Dim instance As DistributionPublisher 
Dim value As RegisteredSubscriberCollection 

value = instance.RegisteredSubscribers

public RegisteredSubscriberCollection RegisteredSubscribers { get; }

public:
property RegisteredSubscriberCollection^ RegisteredSubscribers {
    RegisteredSubscriberCollection^ get ();
}

member RegisteredSubscribers : RegisteredSubscriberCollection

function get RegisteredSubscribers () : RegisteredSubscriberCollection

Property Value

Type: Microsoft.SqlServer.Replication.RegisteredSubscriberCollection
A collection of RegisteredSubscriber objects.

Remarks

This property is only supported for non-SQL Server Publishers. For a SQL Server Publisher, use RegisteredSubscribers.

A RegisteredSubscriber object in the returned RegisteredSubscriberCollection can be accessed from the Item property. This can be done using an [Int32] index value or using a [String] index value that is the Subscriber name.

The RegisteredSubscribers property can only be retrieved by members of the sysadmin fixed server role at the Distributor, by members of the db_owner fixed database role on the distribution database, and by users in the publication access list (PAL) of a publication at the Publisher.

Retrieving the RegisteredSubscribers property is equivalent to executing sp_helpsubscriberinfo at the Distributor.

See Also

Reference

DistributionPublisher Class

Microsoft.SqlServer.Replication Namespace