The following stored procedures are used by replication for server configuration.
| Stored procedure | Description |
|---|---|
| sp_addpublisher | Adds a new publication server. |
| sp_addsubscriber | Adds a new subscription server. |
| sp_changesubscriber | Changes options for a subscription server. |
| sp_dboption | Enables a database to publish or subscribe to replicated data. (Note that sp_dboption can be used to administer many nonreplication database options. For more information, see the Microsoft SQL Server Transact-SQL Reference.) |
| sp_droppublisher | Drops a publication server. |
| sp_dropsubscriber | Drops a subscription server. |
| sp_helpdistributor | Lists information about the distribution server, database, working directory, and SQL Executive user account. |
| sp_helpserver | Lists replication servers known to the server being administered. |
| sp_helpsubscriberinfo | Displays information about a subscription server. |
| sp_replsync | Used from a subscription server to acknowledge completion of a manual synchronization. |
For more information about these stored procedures, see the Microsoft SQL Server Transact-SQL Reference.