Configuration Functions in SQL Server

The following are the list of configuration commands that helps to identify the configured settings information of current instance, in SQL Server.

• @@DATEFIRST
  • This function returns the current value of SET DATEFIRST, for a specific session.
    For a U.S. English environment, @@DATEFIRST defaults to 7 (Sunday).
• @@DBTS
  • This function returns the value of the current timestamp data type for the current database. The current database will have a guaranteed unique timestamp value. It returns a varbinary value.
• @@LANGID
  • Returns the local language identifier (ID) of the language that is currently being used. By default the value will be 0.
• @@LANGUAGE
  • Returns the local language identifier (ID) of the language that is currently being used. If there is no configuration set, the default value will be 0.
• @@LOCK_TIMEOUT
  • Returns the current lock time-out setting in milliseconds for the current session. If nothing configured the value will be -1.
• @@MAX_CONNECTIONS
  • Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. The number returned is not necessarily the number currently configured. The default value is 32767.
• @@MAX_PRECISION
  • Returns the precision level used by decimal and numeric data types as currently set in the server. The default value will be 38.
• @@NESTLEVEL
  • Returns the nesting level of the current stored procedure execution (initially 0) on the local server.
• @@OPTIONS
  • Returns information about the current SET options. Default value is 5496
• @@REMSERVER
  • Returns the name of the remote SQL Server database server as it appears in the login record. NULL if not configured.
• @@SERVERNAME
  • Returns the name of the local server that is running SQL Server. Eg. Default instance or named instance.
• @@SERVICENAME
  • Returns the name of the registry key under which SQL Server is running. @@SERVICENAME returns ‘MSSQLSERVER’ if the current instance is the default instance; this function returns the instance name if the current instance is a named instance.
• @@SPID
  • Returns the session ID of the current user process.
• @@TEXTSIZE
  • Returns the current value of the TEXTSIZE option.
    Default value is 2147483647
• @@VERSION
  • Returns system and build information for the current installation of SQL Server.

I hope you found this post to be informative.

To receive notifications of new posts, please subscribe.