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

Syntax

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

Arguments

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

Remarks

sp_dropmergepartition is used in merge replication.

Permissions

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