Distributor Object

Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

The Distributor object represents the replication Distributor for an instance of Microsoft SQL Server.

Properties

AgentCheckupInterval Property	DistributorInstalled Property
DistributionDatabase Property	DistributorLocal Property
DistributionServer Property	HasRemoteDistributionPublisher Property
DistributorAvailable Property	IsDistributionPublisher Property

Methods

ChangeAgentProfile Method	EnumSnapshotAgentViews Method
CleanUpDistributionPublisherByName Method	EnumThirdPartyPublications Method
CreateAgentProfile Method	GetAgentsStatus Method (Distributor)
DeleteAgentProfile Method	Install Method
EnumAgentProfiles Method	Refresh Method
EnumAgentParameters Method	RemoveDefunctAnonymousSubscriptionMethod
EnumDistributionAgentViews Method	Script Method (Replication Objects)
EnumLogReaderAgentViews Method	SetUpDistributorPassword Method
EnumMergeAgentViews Method	Uninstall Method
UpdateDefaultAgentProfile Method	UpdateAgentProfile Method

Osservazioni

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.

Vedere anche

Riferimento

Distributor2 Object

Guida in linea e informazioni

Assistenza su SQL Server 2005