sys.configurations (Transact-SQL)

Contains a row per 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.

See Also