This topic has not yet been rated - Rate this topic

sys.dm_repl_tranhash (Transact-SQL)

SQL Server 2012

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.

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions