The following stored procedures are used by replication for subscription administration tasks.
| Stored procedure | Description |
|---|---|
| sp_addsubscription | Adds a subscription to a specified article and sets the subscriber's status. |
| sp_changesubscription | On a subscription server, changes subscription properties for an article or a publication. |
| sp_changesubstatus | Changes the status of an existing subscriber. |
| sp_dropsubscription | On the publication server, drops subscriptions to a particular article, publication, or set of subscriptions. |
| sp_helpsubscription | Lists subscription information associated with a particular publication, article, subscriber, or set of subscriptions. |
| sp_subscribe | Remotely adds a subscription to a particular article within a publication. |
| sp_unsubscribe | Remotely cancels a subscription to a particular article within a publication, a whole publication, or to all publications. |
| sp_helpreplicationdb | For an individual database, indicates whether or not the database is subscribed (is a destination database). |
For more information about these stored procedures, see the Microsoft SQL Server Transact-SQL Reference.