sp_deletemergeconflictrow (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_deletemergeconflictrow (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Topic link icon 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.

Community Additions

© 2016 Microsoft