SALES: 1-800-867-1380
Expand Minimize

sys.dm_tran_active_transactions (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see sys.dm_tran_active_transactions (Transact-SQL).

Returns information about transactions for your current logical database.

 

Column Name Data Type Description

transaction_id

bigint

ID of the transaction at the instance level, not the database level. It is only unique across all databases within an instance but not unique across all server instances.

name

nvarchar(64)

Transaction name. This is overwritten if the transaction is marked and the marked name replaces the transaction name.

transaction_begin_time

datetime

Time that the transaction started.

transaction_type

int

Type of transaction.

1 = Read/write transaction

2 = Read-only transaction

3 = System transaction

4 = Distributed transaction

transaction_uow

uniqueidentifier

Transaction unit of work (UOW) identifier for distributed transactions. MS DTC uses the UOW identifier to work with the distributed transaction.

transaction_state

int

0 = The transaction has not been completely initialized yet.

1 = The transaction has been initialized but has not started.

2 = The transaction is active.

3 = The transaction has ended. This is used for read-only transactions.

4 = The commit process has been initiated on the distributed transaction. This is for distributed transactions only. The distributed transaction is still active but further processing cannot take place.

5 = The transaction is in a prepared state and waiting resolution.

6 = The transaction has been committed.

7 = The transaction is being rolled back.

8 = The transaction has been rolled back.

transaction_status

int

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

transaction_status2

int

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

dtc_state

int

In Microsoft Azure SQL Database, this column returns a value of 0 (zero).

dtc_status

int

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

dtc_isolation_level

int

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

filestream_transaction_id

bigint

In Microsoft Azure SQL Database, this column returns a value of 0 (zero).

Requires VIEW DATABASE STATE permission on server.

For more information about the sys.dm_tran_active_transactions system view, see sys.dm_tran_active_transactions (Transact-SQL) in SQL Server Books Online.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft