Edit

Share via

sp_dropmergepartition (Transact-SQL)

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (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.

Transact-SQL syntax conventions

Syntax

syntaxsql 
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