configuration-functions-transact-sql.md

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.service
ms.component	t-sql|functions
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-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
caps.latest.revision	30
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	On Demand

Configuration Functions (Transact-SQL)

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

The following scalar functions return information about current configuration option settings:

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

All configuration functions are nondeterministic. This means these functions do not always return the same results every time they are called, even with the same set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.

See also

Functions (Transact-SQL)