SELECT
db_name(database_id) AS DatabaseName
,type_desc AS TypeDesc
,(size * 8) /1024 AS SizeInMB
,(size * 8) /1024/1024 AS SizeInGB
FROM sys.master_files
ORDER BY name
asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A
SELECT
db_name(database_id) AS DatabaseName
,type_desc AS TypeDesc
,(size * 8) /1024 AS SizeInMB
,(size * 8) /1024/1024 AS SizeInGB
FROM sys.master_files
ORDER BY name