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