CURRENT_REQUEST_ID (Transact-SQL)
Returns the ID of the current request within the current session.
Transact-SQL Syntax Conventions
Syntax
CURRENT_REQUEST_ID()
Return Types
smallint
Remarks
To find exact information about the current session and current request, use @@SPID and CURRENT_REQUEST_ID(), respectively.