Contains one row for each configuration option set by a user. sysconfigures contains the configuration options that are defined before the most recent startup of SQL Server, plus any dynamic configuration options set since then.
|Applies to: SQL Server (SQL Server 2008 through current version).|
|Column name||Data type||Description|
|value||int||User-modifiable value for the variable. This is used by the Database Engine only if RECONFIGURE has been executed.|
|config||int||Configuration variable number.|
|comment||nvarchar(255)||Explanation of the configuration option.|
|status||smallint||Bitmap that indicates the status for the option. Possible values include the following:|
0 = Static. Setting takes effect when the server is restarted.
1 = Dynamic. Variable takes effect when the RECONFIGURE statement is executed.
2 = Advanced. Variable is displayed only when the show advanced options is set. Setting takes effect when the server is restarted.
3 = Dynamic and advanced.