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


SQL Server 2000

  New Information - SQL Server 2000 SP3.

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


sp_helpmergeconflictrows [ [ @publication = ] 'publication' ]
    , [ @conflict_table = ] 'conflict_table'
    [ , [ @publisher = ] 'publisher' ]
    [ , [ @publisher_db = ] 'publsher_db' ]


[@publication = ] 'publication'

Is 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 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 = ] 'conflict_table'

Is the name of the conflict table. conflict_table is sysname, with no default.

[@publisher =] 'publisher'

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

[@publisher_db = ] 'publisher_db'

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

Result Sets

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 = UpdateConflict: Conflict is detected at the row level.
2 = ColumnUpdateConflict: Conflict detected at the column level.
3 = UpdateDeleteWinsConflict: Delete wins the conflict.
4 = UpdateWinsDeleteConflict: The deleted rowguid that loses the conflict is recorded in this table.
5 = UploadInsertFailed: Insert from Subscriber could not be applied at the Publisher.
6 = DownloadInsertFailed: Insert from Publisher could not be applied at the Subscriber.
7 = UploadDeleteFailed: Delete at Subscriber could not be uploaded to the Publisher.
8 = DownloadDeleteFailed: Delete at Publisher could not be downloaded to the Subscriber.
9 = UploadUpdateFailed: Update at Subscriber could not be applied at the Publisher.
10 = DownloadUpdateFailed: Update at Publisher could not be applied to the Subscriber.

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.


sp_helpmergeconflictrows is used in merge replication.


Only members of the sysadmin fixed server role, the db_owner fixed database role, or the publication access list for the current publication can execute sp_helpmergeconflictrows.

See Also

System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.