RegisteredSubscribers Collection (SQL-DMO)

The RegisteredSubscribers collection contains RegisteredSubscriber objects referencing Microsoft® SQL Server™ installations that are maintained as registry entries and are visible to replication as targets for Publisher-originated (push) subscriptions.

Remarks

SQL Server replication enhances the registry-maintained lists of SQL Server installations by associating replication components, such as schedules and security, with registry-listed installations. SQL-DMO makes this association visible through the RegisteredSubscriber object and RegisteredSubscribers collection.

For more information about registry-maintained lists of SQL Server installations, see RegisteredServer Object.

With the RegisteredSubscribers collection, you can:

• Configure a registered SQL Server installation for push subscription by associating replication schedules and security with the named installation.
• Remove replication schedules and security for a SQL Server installation registered and configured for push subscription, disabling push subscription to the installation.
• Generate Transact-SQL script that can be used as part of replication administration, such as a script re-creating configuration parameters for all SQL Server installations.

For more information about configuring push-subscription capable installations by using the RegisteredSubscriber object and RegisteredSubscribers collection, see RegisteredSubscriber Object.

To disable a push subscription to a registered installation

1. Get the appropriate RegisteredSubscribers collection. When disabling a subscription at the Publisher of the data, use the RegisteredSubscribers collection of the Publisher object referencing the publishing installation. When disabling a subscription at the Distributor of the data, use the RegisteredSubscribers collection of the DistributionPublisher object referencing the source of the published data.
2. Use the Remove method of the RegisteredSubscribers collection.

When using the Item or Remove method, the RegisteredSubscribers collection supports member identification using either name or ordinal reference syntax. For example:

Set oRegisteredSubscriber = oPublisher.RegisteredSubscribers("LONDON2")

Or:

Set oRegisteredSubscriber = oPublisher.RegisteredSubscribers(2)

Methods

Properties

Count Property