MergeSubscription Object (SQL-DMO)
The MergeSubscription object represents a push subscription (made from the Publisher) to a merge publication.
Remarks
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
- Create a new MergeSubscription object.
- Set the Subscriber property to the name of an existing Subscriber.
- Set the SubscriptionDB property to the name of the database (at the Subscriber) where the subscription data will be stored.
- Note that the Name property defaults to subscriber:subscription_database.
- Add the MergeSubscription object to the MergeSubscriptions collection of a connected MergePublication object.
To alter an existing merge push subscription
- Get a MergeSubscription object from the MergeSubscriptions collection of a connected MergePublication object.
- Use the BeginAlter method to mark the beginning of the changes.
- Set the MergeSubscription object properties to reflect the changes to the merge push subscription.
- Use the DoAlter method to submit the changes to Microsoft® SQL Server™.
Methods
Properties
(c) 1988-98 Microsoft Corporation. All Rights Reserved.