MSSQL Databases

Check

To show key information about each database...

SELECT sd.database_id,

       sd.name,

       sd.create_date,

       sd.compatibility_level,

       sd.state_desc,

       sd.recovery_model_desc,

       sd.is_encrypted,

       smf.size*8/1024/1024 as sizeGB

  FROM sys.databases sd,

       sys.master_files smf

 WHERE sd.database_id = smf.database_id

   AND smf.type=0

   AND sd.database_id > 4

 ORDER BY database_id

Try also..

EXEC sp_databases

EXEC sp_helpdb

Bibliography