Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

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


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_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 that 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)


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.


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

See Also

System Stored Procedures

© 2015 Microsoft