DisableMergeSubscription Method (SQL-DMO)

The DisableMergeSubscription method removes the record of a Subscriber-initiated (pull) subscription from the merge publication Publisher and Distributor.

Applies To

ReplicationDatabase Object

Syntax

object.DisableMergeSubscription( Subscriber, SubscriptionDatabase,
Publication )

Part	Description
object	Expression that evaluates to an object in the Applies To list
Subscriber	String specifying an existing Subscriber by name
SubscriptionDatabase	String specifying the subscribed database by name
Publication	String specifying an existing merge replication publication by name

Remarks

Removing a pull subscription by using SQL-DMO is a two-step process. The application must remove the subscription at the Subscriber, then, separately, remove the record of the subscription at the Publisher and Distributor.

To remove a pull subscription to a merge replication publication

Establish a SQLServer object connection to the Subscriber.
Extract the MergePullSubscription object referencing the subscription from the Subscriber MergePullSubscriptions collection.
Use the Remove method of the MergePullSubscription object.
Establish a SQLServer object connection to the Publisher.
Use the DisableMergeSubscription method of the ReplicationDatabase object referencing the published database.

Prototype (C/C++)

HRESULT DisableMergeSubscription(
SQLDMO_LPCSTR Subscriber,
SQLDMO_LPCSTR SubscriptionDatabase,
SQLDMO_LPCSTR Publication);