sys.configurations (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains a row for each server-wide configuration option value in the system.

Column nameData typeDescription
configuration_idintUnique ID for the configuration value.
namenvarchar(35)Name of the configuration option.
valuesql_variantConfigured value for this option.
minimumsql_variantMinimum value for the configuration option.
maximumsql_variantMaximum value for the configuration option.
value_in_usesql_variantRunning value currently in effect for this option.
descriptionnvarchar(255)Description of the configuration option.
is_dynamicbit1 = The variable that takes effect when the RECONFIGURE statement is executed.
is_advancedbit1 = The variable is displayed only when the show advancedoption is set.

For a list of all server configuration options, see Server Configuration Options (SQL Server).

System_CAPS_ICON_note.jpg Note

For database-level configuration options, see ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL). To configure Soft-NUMA, see Soft-NUMA (SQL Server).

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

Server-wide Configuration Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)

Community Additions