sys.dm_tran_active_snapshot_database_transactions

Description

Unique identification number assigned for the transaction. The transaction ID is primarily used to identify the transaction in locking operations. Transaction sequence number. This is a unique sequence number that is assigned to a transaction when it starts. Transactions that do not generate version records and do not use snapshot scans will not receive a transaction Sequence number that indicates when the transaction

Syntax

sys.dm_tran_active_snapshot_database_transactions

Examples

Example 1

VIEW SERVER STATE

Example 2

##MS_ServerStateReader##

Example 3

VIEW DATABASE STATE

Example 4

##MS_ServerStateReader##