Export (0) Print
Expand All

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.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft