Transact-SQL Reference

sp_helpmergedeleteconflictrows

Returns the rows in the specified msmerge_delete_conflicts table. This stored procedure is executed at the Publisher on the merge publication database.

Syntax

sp_helpmergedeleteconflictrows [ [ @publication = ] 'publication']
    [ , [ @source_object = ] 'source_object']
    [ , [ @publisher = ] 'publisher'
    [ , [ @publisher_db = ] 'publsher_db'

Arguments

[@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 msmerge_delete_conflicts 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 only.

[@source_object = ] 'source_object'

Is the name of the source object. source_object is nvarchar(386), with a default of NULL.

[@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

Column name	Data type	Description
source_object	nvarchar(386)	Source object for the delete conflict.
rowguid	uniqueidentifier	Row identifier for the delete conflict.
conflict_type	Int	Code indicating 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.
origin_datasource	varchar(255)	Origin of the conflict.
pubid	uniqueidentifier	Publication identifier.

Remarks

sp_helpmergedeleteconflictrows is used in merge replication.

Permissions