Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

Configuration Functions

Configuration functions are very similar to system statistical functions—they also return a single value and do not accept any parameters. Unlike statistical functions, however, the value returned from some of the configuration functions can be changed by altering one of the configuration parameters by using the SET statement, executing sp_configure, or sp_dboption.

The following table summarizes the configuration functions:

Configuration Function



Value of SET DATEFIRST (notice that with DATEFIRST, 1 stands for Monday, 2 stands for Tuesday, and so on)


Current value of TIMESTAMP data type within the current database


Language id of the current language in use


Language name of the current language in use


Lock timeout setting for current connection


Maximum connections allowed on the current instance of SQL Server


Precision level used by default for NUMERIC and DECIMAL data types


Nesting level of current procedure execution (incremented each time one stored procedure executes another)


SET options for the current connection


Name of the remote SQL Server from which a procedure is executed


Name of the local SQL Server


Name of the registry key under which SQL Server is running


Current server process id (spid)


Current value of TEXSIZE option


Date, version, and processor type for the current instance of SQL Server

  • + Share This
  • 🔖 Save To Your Account