sys.database_scoped_configurations (Transact-SQL)
Applies to: SQL Server 2016 (13.x) and later versions Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft 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.