Stored Procedures Used for Replicated Transaction Management

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.