Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sys.configurations (Transact-SQL)

sys.configurations (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Contains a row for each server-wide configuration option value in the system.

Applies to: SQL Server (SQL Server 2008 through current version).

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).

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

Community Additions

ADD
Show:
© 2015 Microsoft