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.

See Also

Other Resources

How to: Manage Partitions for a Merge Publication with Parameterized Filters (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance