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.

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.

Return Code Values

0 (success) or 1 (failure)

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.

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.

See Also

Reference

System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance