Stored Procedures Used for Publication Administration

The following stored procedures are used by replication for publication administration tasks.

Stored procedure Description
sp_addarticle Creates an article and adds it to a publication.
sp_addpublication Creates a publication.
sp_articlecolumn Adds a column to an article. Used to create vertical partitions.
sp_changearticle Changes article properties.
sp_changepublication Changes publication properties.
sp_droparticle Drops an article.
sp_droppublication Drops a publication and its associated articles.
sp_enumfullsubscribers Returns a list of subscribers who have subscribed to all articles in a publication.
sp_helparticle Displays information about an article.
sp_helparticlecolumns Displays all columns in the underlying table. Returns 1 for those that are published and 0 for those that are not published. Useful to check a vertical partition.
sp_helppublication Displays information about a publication.
sp_helppublicationsync Provides information about a replication synchronization task. It is the equivalent of issuing sp_helptask in full mode against the publication task ID.
sp_helpreplicationdb Returns a list of all published databases on the server. Or for an individual database, indicates whether or not the database is published.

For more information about these stored procedures, see the Microsoft SQL Server Transact-SQL Reference.