If you are managing more than 'n' of SQL Server database estate in your organisation then you may required to check some times a specified database current setting in SQL Server to understand.
This below function returns the current setting of the specified database option or property.
DATABASEPROPERTYEX ( database , property )
-- You should defined database name for each function to retrieve the property details
SELECT
DATABASEPROPERTYEX('AdventureWorks2022', 'Collation') AS Collation,
DATABASEPROPERTYEX( 'AdventureWorks2022' , 'IsAutoShrink') AS IsAutoShrink ,
DATABASEPROPERTYEX('AdventureWorks2022', 'Recovery') AS Recovery_State
--Alternatively you can use db_name function for the current database to retrieve the property details
USE [db_name]
GO
SELECT
DATABASEPROPERTYEX( db_name() , 'Collation') AS Collation,
DATABASEPROPERTYEX( db_name() , 'IsAutoShrink') AS IsAutoShrink ,
DATABASEPROPERTYEX( db_name() , 'Recovery') AS Recovery_State
-- Check with Sys.databases to see all the database related property values
SELECT * FROM sys.databases;