| title | sp_helpmergearticlecolumn (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 | 651c017b-9e9a-48f2-a0bd-6fc896eab334 | ||
| caps.latest.revision | 27 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Returns the list of columns in the specified table or view article for a merge publication. Because stored procedures do not have columns, this stored procedure returns an error if a stored procedure is specified as the article. This stored procedure is executed at the Publisher on the publication database.
Transact-SQL Syntax Conventions
sp_helpmergearticlecolumn [ @publication = ] 'publication' ]
, [ @article= ] 'article' ]
[ @publication=] 'publication'
Is the name of the publication.publication is sysname, with no default.
[ @article=] 'article'
Is the name of a table or view that is the article to retrieve information on.article is sysname, with no default.
| Column name | Data type | Description |
|---|---|---|
| column_id | sysname | Identifies the column. |
| column_name | sysname | Is the name of the column for a table or view. |
| published | bit | Specifies if the column name is published. 1 specifies that the column is being published. 0 specifies that it is not published. |
0 (success) or 1 (failure)
sp_helpmergearticlecolumn is used in merge replication.
Only members of the replmonitor fixed database role in the distribution database or the publication access list for the publication can execute sp_helpmergearticlecolumn.