sp-dropmergepartition-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
sp_dropmergepartition (Transact-SQL)	Removes a partition for a parameterized row filter from a publication.	markingmyname	maghan	randolphwest	11/23/2023	sql	replication	reference	sp_dropmergepartition_TSQL sp_dropmergepartition	sp_dropmergepartition	TSQL	>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

sp_dropmergepartition (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

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.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

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

Arguments

[ @publication = ] N'publication'

The name of the publication. @publication is sysname, with no default.

[ @suser_sname = ] N'suser_sname'

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

[ @host_name = ] N'host_name'

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.

Related content

• Manage Partitions for a Merge Publication with Parameterized Filters