sys.configurations (Transact-SQL)

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 advanced option is set.

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

Permissions

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

See Also

Reference

Server-wide Configuration Catalog Views (Transact-SQL)

Catalog Views (Transact-SQL)