CURRENT_TRANSACTION_ID (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance

This function returns the transaction ID of the current transaction in the current session.

Syntax

CURRENT_TRANSACTION_ID( )

bigint

The transaction ID of the current transaction in the current session, taken from sys.dm_tran_current_transaction (Transact-SQL).

Any user can return the transaction ID of the current session.

This example returns the transaction ID of the current session:

SELECT CURRENT_TRANSACTION_ID();