SQL-DMO
DistributionDatabases Collection
The DistributionDatabases collection contains DistributionDatabase objects that expose the properties of Microsoft® SQL Server™ databases used by the replication Distributor for replicated image storage and other tasks.
Methods
| Add Method | Remove Method (Collections) |
| Item Method | Script Method (Replication Objects) |
| Refresh Method |
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
- Get a DistributionDatabase object from the DistributionDatabases collection of a connected Distributor object.
- Use the Remove method.