yesterday, some one asked me , how to get the file size of all databases in MS SQL 2008 using SQL query, So i have decided to write a query in this blog to help to all those developers who don't know.
T-SQL Script
SELECT DB_NAME(DATABASE_ID) AS [DATABASE NAME] ,
CAST(( CAST(SIZE * 8 AS FLOAT) ) / 1024 AS VARCHAR) + ' MB' AS [SIZE]
FROM SYS.MASTER_FILES
Output
