| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | 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 |
[!INCLUDEsqlserver2016-asdb-asdbmi-asa-fabricse-fabricdw]
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.