Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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 iconTransact-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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.