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:
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 |
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 |
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 |
These are the stored procedures used for replication operations:
sp_distcounters | sp_replica |
sp_replcleanup | sp_replsync |
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 |
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.