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.

Topic link icon Transact-SQL Syntax Conventions

Syntax

CURRENT_TRANSACTION_ID( )  
  

Return types

bigint

Return Value

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

Permissions

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

Examples

This example returns the transaction ID of the current session:

SELECT CURRENT_TRANSACTION_ID();  

See also

sp_set_session_context (Transact-SQL)
SESSION_CONTEXT (Transact-SQL)
Row-Level Security
CONTEXT_INFO (Transact-SQL)
SET CONTEXT_INFO (Transact-SQL)