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

sp_helparticlecolumns

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Returns all columns in the underlying table. This stored procedure is executed at the Publisher on the publication database.

Syntax

sp_helparticlecolumns [ @publication = ] 'publication'
     , [ @article = ] 'article'

Arguments

[@publication = ] 'publication'

Is the name of the publication that contains the article. publication is sysname, with no default.

[@article = ] 'article'

Is the name of the article that has its columns returned. article is sysname, with no default.

Return Code Values

0 (columns that are not published) or 1 (columns that are published)

Result Sets
Column name Data type Description
column id int Object ID of the table to which this column belongs.
column sysname Name of the column.
published bit Whether column is published:

0 = No
1 = Yes


Remarks

sp_helparticlecolumns is used in snapshot and transactional replication.

sp_helparticlecolumns is useful in checking a vertical partition.

Permissions

Only members of the sysadmin fixed server role, the db_owner fixed database role, or the publication access list for the current publication can execute sp_helparticlecolumns.

See Also

sp_addarticle

sp_addpublication

sp_articlecolumn

sp_changearticle

sp_changepublication

sp_droparticle

sp_droppublication

sp_enumfullsubscribers

sp_helppublication

System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.