sp_dropmergepublication

Transact-SQL Reference

Transact-SQL Reference

sp_dropmergepublication

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.

Syntax

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

Arguments

[@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)

Remarks

sp_dropmergepublication is used in merge replication.

Permissions

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

See Also

sp_addmergepublication

sp_changemergepublication

sp_helpmergepublication

System Stored Procedures