sysconfigures table

The master..sysconfigures system table stores all configuration options. It contains columns identifying the minimum and maximum values possible for each configuration parameter, as well as the configured value and run value for each parameter.

The status column in sysconfigures cannot be updated by the user. Status 1 means dynamic, indicating that new values for these configuration parameters take effect immediately. The rest of the configuration parameters (those with status 0) take effect only after the reconfigure command has been issued and the server restarted.

You can display the configuration parameters currently in use (run values) by executing the system procedure sp_configure without giving it any parameters.