check_alldatabase_sysfiles

create table ##check_alldatabase_sysfiles(
 [svrname] [nvarchar] (128) NULL ,
 dbname nvarchar(128),
 [fileid] [smallint] NOT NULL ,
 [groupid] [smallint] NOT NULL ,
 [size] [int] NOT NULL ,
 [maxsize] [int] NOT NULL ,
 [growth] [int] NOT NULL ,
 [status] [int] NOT NULL ,
 [perf] [int] NOT NULL ,
 [name] [nchar] (128) NOT NULL ,
 [filename] [nchar] (260) NOT NULL
)

exec sp_MSforeachdb @command1 = '
    use [?];
    insert into ##check_alldatabase_sysfiles select @@servername as srvname, db_name() as dbname, * from sysfiles;
'

select * from ##check_alldatabase_sysfiles;

drop table ##check_alldatabase_sysfiles;