Database Details

create table #dbdetails(name varchar(30), fileid int,filename varchar(1000), filegroup varchar(50), size varchar(30), maxsize varchar(30), growth varchar(30), usage varchar(30))

insert into #dbdetails

EXEC sp_MSforeachdb 'USE [?]; EXEC sp_helpfile;'

select * from #dbdetails

drop table #dbdetails