USE tempdb

GO

DECLARE getDBName CURSOR  FOR
SELECT name
FROM   sys.databases
       
OPEN getDBName

DECLARE  @dbname VARCHAR(101)
DECLARE  @dbsys VARCHAR(101)
DECLARE  @SQL NVARCHAR(2000)
              
IF EXISTS (SELECT *
           FROM   sys.objects
           WHERE  object_id = OBJECT_ID(N'[dbo].[DBGrowth]')
                  AND TYPE IN (N'U'))
  DROP TABLE [dbo].[DBGrowth]
  
CREATE TABLE DBGrowth (
  ServerName NVARCHAR(128),
  DbName     NVARCHAR(128),
  [size]     NVARCHAR(128),
  [MaxSize]  NVARCHAR(128),
  [growth]   NVARCHAR(128),
  DATE       DATETIME)

FETCH NEXT FROM getDBName
INTO @dbname
     
WHILE @@FETCH_STATUS = 0
  BEGIN
    SET @dbsys = '['
                   + @dbname
                   + '].dbo.sysfiles'
    SET @SQL = ('INSERT TEMPDB.dbo.DBGROWTH '
                  + ' SELECT @@SERVERNAME, '''
                  + @dbname
                  + ''',size, maxsize, growth, getDate() '
                  + ' FROM  '
                  + @DbSys)
    PRINT @SQL
    
    EXEC sp_executeSQL
      @SQL
    FETCH NEXT FROM getDBName
    INTO @dbname
         
  END
  
CLOSE getDBName
DEALLOCATE getDBName

SELECT *
FROM   DBGrowth
       

declare @sql varchar(MAX)
set @sql = ''

create TABLE #temp (ID INT IDENTITY (1,1) PRIMARY KEY CLUSTERED, ServerName sysname, DBName sysname, Size int, ReadingDate datetime)

select @sql = @sql + 'INSERT INTO #temp (ServerName, DBName, Size, ReadingDate) select @@ServerName, ''' + name + ''', Size, GETDATE() from [' + name + '].[dbo].[sysfiles];'
from master.sys.databases

EXEC (@sql)

SELECT * FROM #temp

create TABLE #temp (ID INT IDENTITY (1,1) PRIMARY KEY CLUSTERED, ServerName sysname, DBName sysname, Size int, ReadingDate datetime)

EXEC sp_MSforeachdb ' USE ?
INSERT INTO #temp (ServerName, DBName, Size, ReadingDate) 
SELECT @@ServerName as ServerName, 
       Name,
       Size, 
       GETDATE() as ReadingDate
FROM sys.database_files'

SELECT * FROM #temp
drop table #temp