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.

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.

See Also

ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL)