DistributionPublishers Collection

SQL-DMO

SQL-DMO

DistributionPublishers Collection

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

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.