共用方式為


DistributionPublisher.RegisteredSubscribers 屬性

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

命名空間:  Microsoft.SqlServer.Replication
組件:  Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)

語法

'宣告
Public ReadOnly Property RegisteredSubscribers As RegisteredSubscriberCollection 
    Get
'用途
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

屬性值

型別:Microsoft.SqlServer.Replication.RegisteredSubscriberCollection
A collection of RegisteredSubscriber objects.

備註

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.

請參閱

參考

DistributionPublisher 類別

Microsoft.SqlServer.Replication 命名空間