sp-dropmergepartition-transact-sql.md

title	sp_dropmergepartition (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	sp_dropmergepartition_TSQL sp_dropmergepartition
helpviewer_keywords	sp_dropmergepartition
ms.assetid	1be511c1-79ff-4947-9379-78d83b7b8945
author	stevestein
ms.author	sstein
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sp_dropmergepartition (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all-md]

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.

Transact-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

Manage Partitions for a Merge Publication with Parameterized Filters