Transact-SQL Reference
sysconfigures
Contains one row for each configuration option set by a user. sysconfigures contains the configuration options defined before the most recent Microsoft® SQL Server™ startup, plus any dynamic configuration options set since then. This table is only in the master database.
| Column name | Data type | Description |
|---|---|---|
| value | int | User-modifiable value for the variable (being used by SQL Server only if RECONFIGURE has been executed). |
| config | smallint | Configuration variable number. |
| comment | nvarchar(255) | Explanation of the configuration option. |
| status | smallint | Bitmap indicating the status for the option. Possible values include:
0 = Static (The setting takes effect when the server is restarted.). |