735
Need to know all the databases in your SQL Server instance? The simple T-SQL script in this blog post can do just that. You can quickly generate a comprehensive list of all databases in your SQL Server environment along with their state (such as ‘ONLINE’, ‘OFFLINE’. This is an essential query for any database administration task, such as inventory checks, capacity planning, or just to maintain an up-to-date overview of your SQL Server instances. Check out the T-SQL script below and try it out in your environment!
T-Sql
SELECT
[name] AS DatabaseName, -- the name of database
state_desc AS DatabaseState -- describes the state of each database
FROM
sys.databases -- a system catalog view that contains one row per database in the SQL Server instance
ORDER BY
2, 1
