sys-configurations-transact-sql.md

title	sys.configurations (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.configurations_TSQL configurations sys.configurations configurations_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.configurations catalog view
ms.assetid	c4709ed1-bf88-4458-9e98-8e9b78150441
author	stevestein
ms.author	sstein

sys.configurations (Transact-SQL)

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

Contains a row for each server-wide configuration option value in the system.

Column name	Data type	Description
configuration_id	int	Unique ID for the configuration value.
name	nvarchar(35)	Name of the configuration option.
value	sql_variant	Configured value for this option.
minimum	sql_variant	Minimum value for the configuration option.
maximum	sql_variant	Maximum value for the configuration option.
value_in_use	sql_variant	Running value currently in effect for this option.
description	nvarchar(255)	Description of the configuration option.
is_dynamic	bit	1 = The variable that takes effect when the RECONFIGURE statement is executed.
is_advanced	bit	1 = The variable is displayed only when the show advancedoption is set.

For a list of all server configuration options, see Server Configuration Options (SQL Server).

Note

For database-level configuration options, see ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL). To configure Soft-NUMA, see Soft-NUMA (SQL Server).

Permissions

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

See Also

Server-wide Configuration Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)