configuration-functions-transact-sql.md

description	Configuration Functions (Transact-SQL)
title	Configuration Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	07/24/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	reference
dev_langs	TSQL
helpviewer_keywords	functions [SQL Server], configuration configuration options [SQL Server], functions current configuration information configuration functions [SQL Server]
ms.assetid	066f15e7-3406-437e-93c4-3f247c529169
author	cawrites
ms.author	chadam

Configuration Functions (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

These scalar functions return information about current configuration option settings:

• @@DATEFIRST
• @@DBTS
• @@LANGID
• @@LANGUAGE
• @@LOCK_TIMEOUT
• @@MAX_CONNECTIONS
• @@MAX_PRECISION
• @@NESTLEVEL
• @@OPTIONS
• @@REMSERVER
• @@SERVERNAME
• @@SERVICENAME
• @@SPID
• @@TEXTSIZE
• @@VERSION

All configuration functions operate in a nondeterministic way. In other words, these functions do not always return the same results every time they are called, even with the same set of input values. See Deterministic and Nondeterministic Functions for more information about function determinism.

See also

Functions (Transact-SQL)