The following stored procedures are used for replication operations.
| Stored procedure | Description |
|---|---|
| sp_distcounters | Displays the latest information about all subscribers. Used by SQL Performance Monitor. Provides the information used by the counters in the SQLServer Replication-Subscriber object. |
| sp_MSkill_job | On the distribution server, removes a single job from the distribution database while continuing to send all other data to the subscriber. |
| sp_replcleanup | Removes transactions from the distribution database tables after they have been successfully distributed to the subscriber's database. |
| sp_replica | Remotely sets, on a subscription server, a sysobjects category bit that marks the table as a replica (indicates the table is a copy, not an original). Used for informational purposes only. |
| 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.