แก้ไข

แชร์ผ่าน


sp_deletemergeconflictrow (Transact-SQL)

Applies to: SQL Server

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

Transact-SQL syntax conventions

Syntax

sp_deletemergeconflictrow
    [ [ @conflict_table = ] N'conflict_table' ]
    [ , [ @source_object = ] N'source_object' ]
    , [ @rowguid = ] 'rowguid'
    , [ @origin_datasource = ] 'origin_datasource'
    [ , [ @drop_table_if_empty = ] 'drop_table_if_empty' ]
[ ; ]

Arguments

[ @conflict_table = ] N'conflict_table'

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, @origin_datasource, and @source_object, is deleted from the MSmerge_conflicts_info table.

[ @source_object = ] N'source_object'

The name of the source table. @source_object is nvarchar(386), with a default of NULL.

[ @rowguid = ] 'rowguid'

The row identifier for the delete conflict. @rowguid is uniqueidentifier, with no default.

[ @origin_datasource = ] 'origin_datasource'

The origin of the conflict. @origin_datasource is varchar(255), with no default.

[ @drop_table_if_empty = ] 'drop_table_if_empty'

A flag indicating that the @conflict_table is to be dropped if it's 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_conflicts_info table is a system table and isn't deleted from the database, even if it's empty.

Permissions

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