Distributor Object
未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。
The Distributor object represents the replication Distributor for an instance of Microsoft SQL Server.
Properties
Methods
備註
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
Create a new DistributionDatabase object.
Set the Name property to the name of the new distribution database.
Add the DistributionDatabase object to the DistributionDatabases collection of a connected Distributor object.
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).
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.