DistributionPublishers Collection

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The DistributionPublishers collection contains DistributionPublisher objects that expose the properties of Publishers using the referenced Distributor.

SQL-DMO object model that shows the current object

With the DistributionPublishers collection, you can:

  • Add a Publisher to a Distributor.

  • Generate a Transact-SQL command batch to script Publisher configuration for all Publishers using a Distributor.

  • Remove a Publisher from a Distributor.

To remove a Publisher from a Distributor

  1. Get a DistributionPublisher object from the DistributionPublishers collection of a connected Distributor object.

  2. Use the Remove method.

Community Additions