SQL Server (T-SQL)

set nocount on
declare @sql varchar(128)
declare @SourceDB varchar(128)
select @SourceDB = 'ngb01'


 create table #tables(name varchar(128))
 
 select @sql = 'insert #tables select TABLE_NAME from ' + @SourceDB + '.INFORMATION_SCHEMA.TABLES where TABLE_TYPE = ''BASE TABLE'''
 exec (@sql)
 
 create table #SpaceUsed (name varchar(128), rows varchar(11), reserved varchar(18), data varchar(18), index_size varchar(18), unused varchar(18))
 declare @name varchar(128)
 select @name = ''
 while exists (select * from #tables where name > @name)
 begin
  
  select @name = min(name) from #tables where name > @name
  select @sql = 'exec ' + @SourceDB + '..sp_executesql N''insert #SpaceUsed exec sp_spaceused ' + @name + ''''
print @sql
  exec (@sql)
 end
 select * from #SpaceUsed
 drop table #tables
 drop table #SpaceUsed
go