| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.database_scoped_configurations (Transact-SQL) |
sys.database_scoped_configurations (Transact-SQL) |
VanMSFT |
vanto |
05/14/2018 |
sql |
system-objects |
conceptual |
|
|
|
|
=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =azure-sqldw-latest || =fabric |
[!INCLUDE sqlserver2016-asdb-asdbmi-asa-fabricse-fabricdw-fabric]
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. Added in SQL Server 2017. |
Requires membership in the public role.
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.