sys.database_scoped_configurations (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.
elevate_online nvarchar(60) The db scoped default set for the online option for index operations
elevate_resumable nvarchar(60) The db scoped default set for the resumable option for index operations

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

ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)