Stored Procedures–Replication Stored Procedures

This section describes the stored procedures used by replication to implement and initiate replication on a SQL Server 6.0 server. Replication uses stored procedures to perform:

Stored Procedures Used for Server Configuration

These are the stored procedures used by replication for server configuration:

sp_addpublisher sp_dropsubscriber
sp_addsubscriber sp_helpdistributor
sp_changesubscriber sp_helpserver
sp_dboption sp_helpsubscriberinfo
sp_droppublisher sp_replsync

Stored Procedures Used for Publication Administration

These are the stored procedures used by replication for publication administration tasks:

sp_addarticle sp_helparticle
sp_addpublication sp_helparticlecolumns
sp_articlecolumn sp_helppublication
sp_changearticle sp_helppublicationsync
sp_changepublication sp_helpreplicationdb
sp_droparticle sp_replflush
sp_droppublication sp_replstatus
sp_enumfullsubscribers

Stored Procedures Used for Subscription Administration

These are the stored procedures used by replication for subscription administration tasks:

sp_addsubscription sp_helpsubscription
sp_changesubscription sp_subscribe
sp_changesubstatus sp_unsubscribe
sp_dropsubscription sp_helpreplicationdb

Stored Procedures Used for Replication Operations

These are the stored procedures used for replication operations:

sp_distcounters sp_replica
sp_replcleanup sp_replsync

Stored Procedures Used for Replicated Transaction Management

These are the extended stored procedures used to manage and return information about replicated transactions:

sp_MSkill_job sp_repldone
sp_replcmds sp_repltrans
sp_replcounters

Stored Procedures Used for Replication Scheduling

These are the stored procedures used for scheduling of replication tasks in the msdb database:

sp_addtask sp_helptask
sp_droptask

For details, see the SQL Executive stored procedures.