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.