Megosztás a következőn keresztül:

  • Cikk

DistributionPublisher.RegisteredSubscribers Property

Returns 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

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.

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