Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_helpmergearticlecolumn
Collapse the table of content
Expand the table of content

sp_helpmergearticlecolumn

SQL Server 2000

  New Information - SQL Server 2000 SP3.

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.

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 Is the identification number of 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 role in the distribution database or the publication access list for the current publication can execute sp_helpmergearticlecolumn.

See Also

Replication Monitor

Publication Access Lists

System Stored Procedures

Show:
© 2015 Microsoft