Skip to content

Latest commit

 

History

History
77 lines (52 loc) · 2.84 KB

sp-deletemergeconflictrow-transact-sql.md

File metadata and controls

77 lines (52 loc) · 2.84 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_deletemergeconflictrow (Transact-SQL)
Deletes rows from a conflict table or the MSmerge_conflicts_info table.
markingmyname
maghan
randolphwest
08/22/2024
sql
replication
reference
sp_deletemergeconflictrow
sp_deletemergeconflictrow_TSQL
sp_deletemergeconflictrow
TSQL

sp_deletemergeconflictrow (Transact-SQL)

[!INCLUDE SQL Server]

Deletes rows from a conflict table or the MSmerge_conflicts_info table. This stored procedure is executed at the computer where the conflict table is stored, in any database.

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

Syntax

sp_deletemergeconflictrow
    [ [ @conflict_table = ] N'conflict_table' ]
    [ , [ @source_object = ] N'source_object' ]
    , [ @rowguid = ] 'rowguid'
    , [ @origin_datasource = ] 'origin_datasource'
    [ , [ @drop_table_if_empty = ] 'drop_table_if_empty' ]
[ ; ]

Arguments

[ @conflict_table = ] N'conflict_table'

The name of the conflict table. @conflict_table is sysname, with a default of %. If the @conflict_table is specified as NULL or %, the conflict is assumed to be a delete conflict and the row matching @rowguid, @origin_datasource, and @source_object, is deleted from the MSmerge_conflicts_info table.

[ @source_object = ] N'source_object'

The name of the source table. @source_object is nvarchar(386), with a default of NULL.

[ @rowguid = ] 'rowguid'

The row identifier for the delete conflict. @rowguid is uniqueidentifier, with no default.

[ @origin_datasource = ] 'origin_datasource'

The origin of the conflict. @origin_datasource is varchar(255), with no default.

[ @drop_table_if_empty = ] 'drop_table_if_empty'

A flag indicating that the @conflict_table is to be dropped if it's empty. @drop_table_if_empty is varchar(10), with a default of false.

Return code values

0 (success) or 1 (failure).

Remarks

sp_deletemergeconflictrow is used in merge replication.

MSmerge_conflicts_info table is a system table and isn't deleted from the database, even if it's empty.

Permissions

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

Related content