How to Check Database State?

SELECT name, state_desc from sys.databases 

GO

Last Updated: June 10, 2022