Database Size in MB

SELECT SUM (size*.008) AS database_size_in_MB, DB_NAME (dbid) AS database_name
FROM sys.sysaltfiles
WHERE DB_NAME (dbid) IS NOT NULL
GROUP BY DB_NAME (dbid)