Transact-SQL Reference
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.). |