sp_articlecolumn Replication Stored Procedure

Modifies columns for an article. Use sp_articlecolumn to create vertical partitions.

Syntax

sp_articlecolumn publication, article [, 'column'
[, @operation = {'add' | 'drop'}]]

where

publication

Is the name of the publication that contains this article.

article

Is the name of the article.

column

Is the name of the column to be added or dropped. The default is NULL. If NULL, all columns are published.

@operation

Specifies the replication status; add (the default) marks the column for replication; drop unmarks the column.

Remarks

This stored procedure sets a bit in sysarticles. Only an unsubscribed article can be partitioned using sp_articlecolumn.

Example

This example modifies the column col5, marking it for replication.

sp_articlecolumn PUB_TEST, ART_ALLS, 'col5', 'add'

Permission

Execute permission defaults to the system administrator and database owner.

Tables Used

syscolumns, sysarticles, syspublications, sysdatabases

See Also