共用方式為


MergeSubscription Object

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The MergeSubscription object represents a push subscription (made from the Publisher) to a merge publication.

顯示目前物件的 SQL-DMO 物件模型

Properties

EnabledForSyncMgr Property

Subscriber Property

MergeJobID Property

SubscriberType Property (MergePullSubscription, MergeSubscription)

Name Property

SubscriptionDB Property

Priority Property

SubscriptionType Property

Status Property (Subscription Objects)

SyncType Property

Methods

BeginAlter Method

ReInitialize Method

CancelAlter Method

Remove Method (Objects)

DoAlter Method

Script Method (Replication Objects)

備註

With the MergeSubscription object, you can:

  • Add a push subscription to a merge publication.
  • Change the properties of an existing push merge subscription.

To create a merge push subscription at the Publisher

  1. Create a new MergeSubscription object.

  2. Set the Subscriber property to the name of an existing Subscriber.

  3. Set the SubscriptionDB property to the name of the database (at the Subscriber) where the subscription data will be stored.

  4. Note that the Name property defaults to subscriber**:**subscription_database.

  5. Add the MergeSubscription object to the MergeSubscriptions collection of a connected MergePublication object.

To alter an existing merge push subscription

  1. Get a MergeSubscription object from the MergeSubscriptions collection of a connected MergePublication object.

  2. Use the BeginAlter method to mark the beginning of the changes.

  3. Set the MergeSubscription object properties to reflect the changes to the merge push subscription.

  4. Use the DoAlter method to submit the changes to Microsoft SQL Server.

ms133971.note(zh-tw,SQL.90).gif附註:
The MergeSubscription object is compatible with instances of SQL Server versions 7.0 and later. However, the MergeSubscription2 object extends the functionality of the MergeSubscription object for use with features that were introduced in SQL Server 2000.

請參閱

參考

MergeSubscription2 Object

說明及資訊

取得 SQL Server 2005 協助