These 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; they do not always return the same results every time they are called with a specific set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.