syscurconfigs
Contains an entry for each of the current configuration options. In addition, this table contains four entries that describe the configuration structure. syscurconfigs is built dynamically when queried by a user. For more information, see sysconfigures.
| Column name | Data type | Description |
|---|---|---|
| value | int | User-modifiable value for the variable (being used by Microsoft® 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.). |