sp_repltrans Replication Stored Procedure

Returns a result set of all the transactions in the publication database transaction log that are marked for replication but have not been marked as distributed.

Syntax

sp_repltrans

Remarks

This replication stored procedure returns information about the publication database from which it is executed. It allows you to view transactions currently not distributed (those transactions remaining in the transaction log that have not been sent to the distribution server). It returns a results set displaying the row identifier (RID, containing the page and row) and the timestamp for each transaction. It is similar to the sp_replcmds stored procedure but does not return the commands for the transactions.

Example

This example returns all transactions in the publication database transaction log marked for publication but not yet distributed.

sp_repltrans
go
page        row    timestamp          
----------- ------ ------------------ 
5131        0      0x00000001000011d6 

(1 row(s) affected)

Permission

Execute permission defaults to the system administrator.

Table Used

None.

See Also