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.
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
