sp_helpmergeconflictrows (Transact-SQL)

Artikel
2023-11-24

Applies to: SQL Server

Returns the rows in the specified conflict table. This stored procedure is run on the computer where the conflict table is stored.

Transact-SQL syntax conventions

Syntax

sp_helpmergeconflictrows
    [ [ @publication = ] N'publication' ]
    , [ @conflict_table = ] N'conflict_table'
    [ , [ @publisher = ] N'publisher' ]
    [ , [ @publisher_db = ] N'publisher_db' ]
    [ , [ @logical_record_conflicts = ] logical_record_conflicts ]
[ ; ]

Arguments

[ @publication = ] N'publication'

The name of the publication. @publication is sysname, with a default of %. If the publication is specified, all conflicts qualified by the publication are returned. For example, if the MSmerge_conflict_Customers table has conflict rows for the WA and the CA publications, passing in a publication name CA retrieves conflicts that pertain to the CA publication.

[ @conflict_table = ] N'conflict_table'

The name of the conflict table. @conflict_table is sysname, with no default. Conflict tables are named using the format names with MSmerge_conflict__publication_article_*, with one table for each published article.

[ @publisher = ] N'publisher'

The name of the Publisher. @publisher is sysname, with a default of NULL.

[ @publisher_db = ] N'publisher_db'

The name of the publisher database. @publisher_db is sysname, with a default of NULL.

[ @logical_record_conflicts = ] logical_record_conflicts

Indicates whether the result set contains information about logical record conflicts. @logical_record_conflicts is int, with a default of 0. 1 means that logical record conflict information is returned.

Result set

sp_helpmergeconflictrows returns a result set consisting of the base table structure and these additional columns.

Column name	Data type	Description
`origin_datasource`	varchar(255)	Origin of the conflict.
`conflict_type`	int	Code indicating the type of conflict: `1` = Update Conflict: The conflict is detected at the row level. `2` = Column Update Conflict: The conflict detected at the column level. `3` = Update Delete Wins Conflict: The delete wins the conflict. `4` = Update Wins Delete Conflict: The deleted `rowguid` that loses the conflict is recorded in this table. `5` = Upload Insert Failed: The insert from Subscriber couldn't be applied at the Publisher. `6` = Download Insert Failed: The insert from Publisher couldn't be applied at the Subscriber. `7` = Upload Delete Failed: The delete at Subscriber couldn't be uploaded to the Publisher. `8` = Download Delete Failed: The delete at Publisher couldn't be downloaded to the Subscriber. `9` = Upload Update Failed: The update at Subscriber couldn't be applied at the Publisher. `10` = Download Update Failed: The update at Publisher couldn't be applied to the Subscriber. `12` = Logical Record Update Wins Delete: The deleted logical record that loses the conflict is recorded in this table. `13` = Logical Record Conflict Insert Update: Insert to a logical record conflicts with an update. `14` = Logical Record Delete Wins Update Conflict: The updated logical record that loses the conflict is recorded in this table.
`reason_code`	int	Error code that can be context-sensitive.
`reason_text`	varchar(720)	Error description that can be context-sensitive.
`pubid`	uniqueidentifier	Publication identifier.
`MSrepl_create_time`	datetime	Time the conflict information was added.

Return code values

0 (success) or 1 (failure).

Remarks

sp_helpmergeconflictrows is used in merge replication.

Permissions

Only members of the sysadmin fixed server role, the db_owner fixed database role, and the replmonitor role in the distribution database can execute sp_helpmergeconflictrows.

Dela via