The following extended stored procedures are used to manage and return information about replicated transactions. Generally, these are used only for troubleshooting.
| Stored procedure | Description |
|---|---|
| sp_replcmds | Returns the commands for transactions marked for replication. |
| sp_replcounters | Returns replication statistics for all published databases. Used by SQL Performance Monitor. Provides the information used by the counters in the SQLServer Replication-Published DB object. |
| sp_repldone | Updates the record identifying the server's last distributed transaction. |
| sp_replflush | Flushes the article cache. |
| sp_replstatus | Used to update the internal table structure for replication (that indicates whether the table is being replicated). |
| sp_repltrans | Returns a result set of all the transactions in the publication database transaction log that are marked for replication but that have not been marked as distributed. |
For more information about these stored procedures, see the Microsoft SQL Server Transact-SQL Reference.