sys.database_scoped_configurations (Transact-SQL)
Applies to:
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
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.