Configuration Functions (Transact-SQL)
Applies to: 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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for