CURRENT_REQUEST_ID (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This function returns the ID of the current request within the current session.

Topic link icon Transact-SQL Syntax Conventions

Syntax

CURRENT_REQUEST_ID()  

Return types

smallint

Remarks

To find exact information about the current session, use @@SPID. For exact information about the current request, use CURRENT_REQUEST_ID().

See also

@@SPID (Transact-SQL)