| title | sp_deletemergeconflictrow (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | replication | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 64cf1186-28b8-4cd9-88f1-a7808a9c8d60 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Deletes rows from a conflict table or the MSmerge_conflicts_info (Transact-SQL) table. This stored procedure is executed at the computer where the conflict table is stored, in any database.
Transact-SQL Syntax Conventions
sp_deletemergeconflictrow [ [ @conflict_table = ] 'conflict_table' ]
[ , [ @source_object = ] 'source_object' ]
{ , [ @rowguid = ] 'rowguid'
, [ @origin_datasource = ] 'origin_datasource' ] }
[ , [ @drop_table_if_empty = ] 'drop_table_if_empty' ]
[ @conflict_table = ] 'conflict_table'
Is 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 and origin_datasource and source_object is deleted from the MSmerge_conflicts_info (Transact-SQL) table.
[ @source_object = ] 'source_object'
Is the name of the source table. source_object is nvarchar(386), with a default of NULL.
[ @rowguid = ] 'rowguid'
Is the row identifier for the delete conflict. rowguid is uniqueidentifier, with no default.
[ @origin_datasource = ] 'origin_datasource'
Is the origin of the conflict. origin_datasource is varchar(255), with no default.
[ @drop_table_if_empty = ] 'drop_table_if_empty'
Is a flag indicating that the conflict_table is to be dropped if is empty. drop_table_if_empty is varchar(10), with a default of FALSE.
0 (success) or 1 (failure)
sp_deletemergeconflictrow is used in merge replication.
MSmerge_conflicts_info (Transact-SQL) table is a system table and is not deleted from the database, even if it is empty.
Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_deletemergeconflictrow.