sp_deletemergeconflictrow (T-SQL)

Deletes rows from a conflict table or the msmerge_delete_conflicts table.

Syntax

sp_deletemergeconflictrow [[@conflict_table =] 'conflict_table']
    [,[@source_object =] 'source_object'] {,[@rowguid =] 'rowguid',
    [@origin_datasource =] 'origin_datasource']}
    [,[@drop_table_if_empty =] 'drop_table_if_empty']

Arguments

[@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_delete_conflicts 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 whether the conflict_table is to be dropped if is 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_delete_conflicts is a system table and is not deleted from the database, even if it is empty.

Permissions

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