sys.dm_repl_tranhash (Transact-SQL)
Returns information about transactions being replicated in a transactional publication.
column_name |
data_type |
description |
|---|---|---|
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. |
Permissions
Requires VIEW DATABASE STATE permission on the publication database to call dm_repl_tranhash.
Remarks
Information is only returned for replicated database objects that are currently loaded in the replication article cache.