Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

  New Information - SQL Server 2000 SP3.

Drops a merge publication and its associated Snapshot Agent. All subscriptions must be dropped before dropping merge publications. The articles in the publication are dropped automatically. This stored procedure is executed at the Publisher on the publication database.


sp_dropmergepublication [ @publication = ] 'publication'
    [ , [ @ignore_distributor = ] ignore_distributor ]
    [ , [ @reserved = ] reserved ]


[@publication = ] 'publication'

Is the name of the publication to drop. publication is sysname, with no default. If all, all existing merge publications are removed as well as the snapshot associated with them. If other values are specified, the Snapshot Agent associated with that publication is dropped.

[@ignore_distributor = ] ignore_distributor

ignore_distributor is bit, with a default of 0. This parameter can be used to drop a publication without doing cleanup tasks at the Distributor. It is also useful if you had to reinstall the Distributor.

[@reserved = ] reserved

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

Return Code Values

0 (success) or 1 (failure)


sp_dropmergepublication is used in merge replication.

sp_dropmergepublication cannot be executed from within a transaction.


Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_dropmergepublication.

See Also




System Stored Procedures

© 2015 Microsoft