sp_helpmergedeleteconflictrows (T-SQL)

Returns the rows in the specified msmerge_delete_conflicts table.

sp_helpmergedeleteconflictrows [[@publication =] 'publication']
[,[@source_object =] 'source_object']

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

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 = Update conflict 2 = Upload error 3 = Download error 4 = Update delete conflict 5 = Column update conflict
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

sp_helpmergedeleteconflictrows is used in merge replication.

Execute permissions default to the public role.