Export (0) Print
Expand All
3 out of 6 rated this helpful - Rate this topic

Configuration Functions

SQL Server 2000

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.

See Also

Functions

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.