DistributionPublisher.RegisteredSubscribers 속성

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

네임스페이스:  Microsoft.SqlServer.Replication
어셈블리:  Microsoft.SqlServer.Rmo(Microsoft.SqlServer.Rmo.dll)

public RegisteredSubscriberCollection RegisteredSubscribers { get; }

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.