Export (0) Print
Expand All
Expand Minimize

sp_dropmergepartition (Transact-SQL)

Removes a partition for a parameterized row filter from a publication. This stored procedure is executed at the Publisher on the publication database. This stored procedure also removes the corresponding snapshot job and snapshot files for the partition.

Topic link iconTransact-SQL Syntax Conventions

sp_dropmergepartition [ @publication = ] 'publication', [ @suser_sname = ] 'suser_sname', [ @host_name = ] 'host_name'

[ @publication] = 'publication'

Is the name of the publication. publication is sysname, with no default.

[ @suser_sname= ] 'suser_sname'

Is the value of the SUSER_SNAME function at the Subscriber used to define the partition. suser_sname is sysname, with no default.

[ @host_name = ] 'host_name'

Is the value of the HOST_NAME function at the Subscriber used to define the partition. host_name is sysname, with no default.

0 (success) or 1 (failure)

sp_dropmergepartition is used in merge replication.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft