Returns information about transactions being replicated in a transactional publication.
|Applies to: SQL Server ( SQL Server 2008 through current version).|
|buckets||bigint||Number of buckets in the hash table.|
|hashed_trans||bigint||Number of committed transactions replicated in the current batch.|
|completed_trans||bigint||Number of transactions competed so far.|
|compensated_trans||bigint||Number of transactions that contain partial rollbacks.|
|first_begin_lsn||nvarchar(64)||Earliest begin log sequence number (LSN) in the current batch.|
|last_commit_lsn||nvarchar(64)||Last commit LSN in the current batch.|
Requires VIEW DATABASE STATE permission on the publication database to call dm_repl_tranhash.
Information is only returned for replicated database objects that are currently loaded in the replication article cache.