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.
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.
Return Code Values
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.