Gameroff

SELECT sum(CONVERT(decimal(10,2), F.size * 0.0078125)) AS [size_on_disk_mb] FROM sys.master_files AS F INNER JOIN sys.databases AS D ON F.database_id = D.database_id --where type_desc like '%%'