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
No comments:
Post a Comment