sp_helpmergearticleconflicts (T-SQL)

Returns the articles in the publication that have conflicts.

sp_helpmergearticleconflicts [[@publication =] 'publication']

[@publication =] 'publication': Is the name of the publication. publication is sysname, with a default of %, which returns all articles in the database that have conflicts.

Column name	Data type	Description
article	sysname	Name of the article
source_object	nvarchar(386)	Name of the source object
conflict_table	nvarchar(258)	Name of the table storing the insert or update conflicts
guidcolname	sysname	Name of the RowGuidCol for the source object
centralized_conflicts	int	Whether conflict records are stored on the given Publisher

If the article has only delete conflicts and no conflict_table rows, the name of the conflict_table in the result set is NULL.

sp_helpmergearticleconflicts is used in merge replication.

Execute permissions default to the public role.