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.
sp_helparticlecolumns [ @publication = ] 'publication'
, [ @article = ] 'article'
[@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)
|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
sp_helparticlecolumns is used in snapshot and transactional replication.
sp_helparticlecolumns is useful in checking a vertical partition.
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.