Listar información de las bases de datos de SQL Server

Con esta query tenemos toda la información que necesitamos:

Select a.database_id, a.type_desc, a.name, a.physical_name, a.state, a.state_desc, (a.size*8) as size,
a.max_size, a.growth, c.create_date, c.compatibility_level, c.collation_name, c.user_access_desc,
c.recovery_model_desc, c.log_reuse_wait_desc
From sys.master_files as a
LEFT JOIN sys.databases as c On a.database_id = c.database_id
Order by size desc

y esto es todo, feliz programming!!
Saludos
Alex.