Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

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

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.