MSSQL Databases
Check
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
Bibliography