Contains one row for each configuration option that can be set by a user. The sysconfigures table contains the configuration options that were defined before the latest SQL Server startup, plus any dynamic configuration options that were set since the latest SQL Server startup.
| Column | Datatype | Description |
|---|---|---|
| config | smallint | Configuration variable number |
| value | int | User-modifiable value for the variable (being used by SQL Server only if RECONFIGURE has been executed) |
| comment | varchar(255) | Explanation of the configuration option |
| status | smallint | Bitmap indicating the status for the option: 1 Dynamic (The variable takes effect when the RECONFIGURE statement is executed.)
2 Advanced (The variable is displayed |
sysconfigures clustered, unique on config
| sp_configure |