Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

Topic link icon 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.