Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.database_scoped_configurations (Transact-SQL)
Applies to: 👁 Image
SQL Server 2016 (13.x) and later versions 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
Warehouse in Microsoft Fabric 👁 Image
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. |
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
Feedback
Was this page helpful?