Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize


SQL Server 2000

Drops a merge pull subscription. This stored procedure is executed at the Subscriber on the subscription database.


sp_dropmergepullsubscription [ [ @publication = ] 'publication' ]
    [ , [ @publisher = ] 'publisher' ]
    [ , [ @publisher_db = ] 'publisher_db' ]
    [ , [ @reserved = ] 'reserved' ]


[@publication = ] 'publication'

Is the name of the publication. publication is sysname, with a default of NULL.

[@publisher = ] 'publisher'

Is the name of the Publisher. publisher is sysname, with a default of NULL.

[@publisher_db = ] 'publisher_db'

Is the name of the Publisher database. publisher_db is sysname, with a default of NULL.

[@reserved = ] reserved

Is reserved for future use. reserved is bit, with a default of 0.

Return Code Values

0 (success) or 1 (failure)


sp_dropmergepullsubscription is used in merge replication.

sp_dropmergepullsubscription drops the Merge Agent for this merge pull subscription, although the Merge 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.

See Also




System Stored Procedures

© 2015 Microsoft