Yes, is_value_default has now been added to the DMV sys.database_scoped_configurations in SQL Server 2017 to allow easier detection of default deviations.
1 = Default value
Hopefully we will see this included in SQL Server 2016 as part of a patching cycle.
Previous
Next