Contains an entry for each current configuration option. Also, this view contains four entries that describe the configuration structure. syscurconfigs is built dynamically when queried by a user. For more information, see sys.sysconfigures (Transact-SQL).
|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 SQL Server Database Engine 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 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.
3 = Dynamic and advanced.