current-request-id-transact-sql.md

description	CURRENT_REQUEST_ID (Transact-SQL)
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	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	markingmyname
ms.author	maghan

CURRENT_REQUEST_ID (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

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

Transact-SQL Syntax Conventions

Syntax

CURRENT_REQUEST_ID()  

[!INCLUDEsql-server-tsql-previous-offline-documentation]

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)