sys-syscurconfigs-transact-sql.md

title	sys.syscurconfigs (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.syscurconfigs sys.syscurconfigs_TSQL syscurconfigs syscurconfigs_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.syscurconfigs compatibility view syscurconfigs system table
ms.assetid	454ab849-07a5-4b50-ba0a-6b1b14721f77
author	rothja
ms.author	jroth

sys.syscurconfigs (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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).

Important

[!INCLUDEssnoteCompView]

Column name	Data type	Description
value	int	User-modifiable value for the variable. This is used by the [!INCLUDEssDEnoversion] 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.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)