Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_deletemergeconflictrow (Transact-SQL)

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft