sys-sysconfigures-transact-sql.md

title	sys.sysconfigures (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.sysconfigures sysconfigures sys.sysconfigures_TSQL sysconfigures_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.sysconfigures compatibility view sysconfigures system table
ms.assetid	146bf10a-c898-4676-a2a1-673fb1cee7a2
author	rothja
ms.author	jroth

sys.sysconfigures (Transact-SQL)

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

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 [!INCLUDEssNoVersion], plus any dynamic configuration options set since then.

Important

[!INCLUDEssnoteCompView]

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

See Also

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