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.
See Also
(c) 1988-98 Microsoft Corporation. All Rights Reserved.