sp_helpmergedeleteconflictrows

Transact-SQL Reference

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

Execute permissions default to the public role.

See Also

System Stored Procedures