sp_helpmergearticlecolumn (Transact-SQL)
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.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
sp_helpmergearticlecolumn [ @publication = ] 'publication' ]
, [ @article= ] 'article' ]
Arguments
[ @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.
Result Sets
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. |
Return Code Values
0 (success) or 1 (failure)
Remarks
sp_helpmergearticlecolumn is used in merge replication.
Permissions
Only members of the replmonitor fixed database role in the distribution database or the publication access list for the publication can execute sp_helpmergearticlecolumn.