DistributionDatabases Collection (SQL-DMO)

The DistributionDatabases collection contains DistributionDatabase objects exposing the properties of Microsoft® SQL Server™ databases used by the replication Distributor for replicated image storage and other tasks.

Remarks

The DistributionDatabases collection stores a list of distribution databases available at the Distributor. A Publisher using the Distributor selects a single distribution database for each publication managed by the Distributor.

With the DistributionDatabases collection, you can:

• Create a SQL Server database for Distributor use.
• Generate a Transact-SQL command batch to script database creation for all databases used by a Distributor.
• Remove a distribution database.

To remove a distribution database from the Distributor

1. Get a DistributionDatabase object from the DistributionDatabases collection of a connected Distributor object.
2. Use the Remove method.

Methods