Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Database Engine
Technical Reference
SQL-DMO Reference
Objects
D (SQL-DMO Objects)
 Distributor Object
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (October 2008)
Distributor Object

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 Distributor object represents the replication Distributor for an instance of Microsoft SQL Server.

SQL-DMO object model that shows the current object

With the Distributor object, you can:

  • Install a local Distributor or configure remote distribution for a Publisher.
  • Uninstall a local Distributor or stop remote distribution.
To install a local Distributor and distribution database
  1. Create a new DistributionDatabase object.

  2. Set the Name property to the name of the new distribution database.

  3. Add the DistributionDatabase object to the DistributionDatabases collection of a connected Distributor object.

  4. Set the DistributionServer property of a connected Distributor object to the name of the local instance of SQL Server (available in the TrueName property of a connected SQLServer object).

  5. Use the Install method of the connected Distributor object.

To uninstall a local Distributor and distribution database
  • Use the Uninstall method of a connected Distributor object.

Note   The Distributor object is compatible with instances of SQL Server versions 7.0 and later. However, the Distributor2 object extends the functionality of the Distributor object for use with features that were introduced in SQL Server 2000.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker