configuration-functions-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	dev_langs
Configuration Functions (Transact-SQL)	Configuration Functions (Transact-SQL)	markingmyname	maghan	07/24/2017	sql	t-sql	reference	functions [SQL Server], configuration configuration options [SQL Server], functions current configuration information configuration functions [SQL Server]	TSQL

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)