Drops a merge pull subscription.
sp_dropmergepullsubscription [[@publication =] 'publication']
[,[@publisher =] 'publisher'] [,[@publisher_db =] 'publisher_db']
0 (success) or 1 (failure)
sp_dropmergepullsubscription is used in merge replication.
sp_dropmergepullsubscription drops the agent for this merge pull subscription, although the agent is not created in sp_addmergepullsubscription. Also note that the local server and current database are assumed to be the subscriber and subscriber_db.
Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_dropmergepullsubscription.
sp_addmergepullsubscription | sp_helpmergepullsubscription |
sp_changemergepullsubscription | System Stored Procedures |