Script Code: use master
go
Create procedure usp_getmdfsize @dbname varchar(128)
as
declare @query varchar(200)
set @query ='begin use ' + @dbname + ' End begin DBCC showfilestats end'
create table #mytable(Fileid int, FileGroup int, Totalextents bigint,UsedExtents bigint,Name varchar(256),Filename varchar(600))
insert #mytable exec (@query)
select Name as DatabaseName,Filename,(TotalExtents*64)/1024 as TotalMB,(Usedextents*64)/1024 as UsedMB,
Free= ((TotalExtents*64) - (Usedextents*64))/1024, 
FreePercent=(((TotalExtents*64*1.0) - (Usedextents*64*1.0))/(TotalExtents*64*1.0))*100
from #mytable 
drop table #mytable
go