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