current-request-id-transact-sql.md

title	CURRENT_REQUEST_ID (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	07/24/2017
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	CURRENT_REQUEST_ID_TSQL CURRENT_REQUEST_ID
dev_langs	TSQL
helpviewer_keywords	CURRENT_REQUEST_ID
ms.assetid	949f6e5f-bf5f-49d6-a763-c443d1d51fe2
author	MikeRayMSFT
ms.author	mikeray

CURRENT_REQUEST_ID (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

This function 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, use @@SPID. For exact information about the current request, use CURRENT_REQUEST_ID().

See also

@@SPID (Transact-SQL)