sys.configurations (Transact-SQL)

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 name Data type Description
configuration_id int Unique ID for the configuration value.
name nvarchar(35) Name of the configuration option.
value sql_variant Configured value for this option.
minimum sql_variant Minimum value for the configuration option.
maximum sql_variant Maximum value for the configuration option.
value_in_use sql_variant Running value currently in effect for this option.
description nvarchar(255) Description of the configuration option.
is_dynamic bit 1 = The variable that takes effect when the RECONFIGURE statement is executed.
is_advanced bit 1 = 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).


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.

See Also

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