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.