| title | sp_helpmergearticleconflicts (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 4678a2b9-9a5f-4193-a20d-2e11fc896c3a | ||
| caps.latest.revision | 28 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Returns the articles in the publication that have conflicts. This stored procedure is executed at the Publisher on the publication database, or at the Subscriber on the merge subscription database.
Transact-SQL Syntax Conventions
sp_helpmergearticleconflicts [ [ @publication = ] 'publication' ]
[ , [ @publisher = ] 'publisher' ]
[ , [ @publisher_db = ] 'publsher_db' ]
[ @publication=] 'publication'
Is the name of the merge publication.publication is sysname, with a default of %, which returns all articles in the database that have conflicts.
[ @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.
| Column name | Data type | Description |
|---|---|---|
| article | sysname | Name of the article. |
| source_owner | sysname | Owner of the source object. |
| 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.
0 (success) or 1 (failure)
sp_helpmergearticleconflicts is used in merge replication.
Only members of the sysadmin fixed server role and the db_owner fixed database role can execute sp_helpmergearticleconflicts.