Share via

DistributionPublishers Collection

  • Article

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

Methods

Add Method

Remove Method (Collections)

Item Method

Script Method (Replication Objects)

Refresh Method

 

Remarks

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.