sys-database-scoped-configurations-transact-sql.md

title	sys.database_scoped_configurations (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	05/14/2018
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	system-objects
ms.topic	conceptual
f1_keywords	database_scoped_configurations database_scoped_configurations_TSQL sys.database_scoped_configurations sys.database_scoped_configurations_TSQL
helpviewer_keywords	sys.database_scoped_configurations catalog view
ms.assetid	8899310a-3464-4d38-9f2f-88396c4e7dc2
author	VanMSFT
ms.author	vanto
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.database_scoped_configurations (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]

Contains one row per configuration.

Column name	Data type	Description
configuration_id	int	ID of the configuration option.
name	nvarchar(60)	The name of the configuration option. For information about the possible configurations, see ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL).
value	sqlvariant	The value set for this configuration option for the primary replica.
value_for_secondary	sqlvariant	The value set for this configuration option for the secondary replicas.
is_value_default	bit	Specifies whether the value set is the default value.

Permissions

Requires membership in the public role.

Remarks

When NULL is returned as the value for value_for_secondary, this means that the secondary is set to PRIMARY.

Database scoped configuration settings will be carried over with the database. This means that when a given database is restored or attached, the existing configuration settings remain.

See Also

ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)