sysconfigures

Contains one row for each configuration option set by a user. sysconfigures contains the configuration options defined before the most recent Microsoft® SQL Server™ startup, plus any dynamic configuration options set since then. This table is only in the master database.

Column name	Data type	Description
value	int	User-modifiable value for the variable (being used by 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.). 1 = Dynamic (The variable takes effect when the RECONFIGURE statement is executed.). 2 = Advanced (The variable is displayed only when the show advanced option is set.). 3 = Dynamic and advanced.