sp_helpmergeconflictrows (T-SQL)

Returns the rows in the specified conflict table.

sp_helpmergeconflictrows [[@publication =] 'publication']
{,[@conflict_table =] 'conflict_table'}

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

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 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
pubid	uniqueidentifier	Publication identifier

sp_helpmergeconflictrows is used in merge replication.

Execute permissions default to the public role.