CREATE TABLE #temp(
	DBName varchar(128),
	RecID  int IDENTITY (1, 1),
 	TableName varchar(128),
 	NbrOfRows int,
 	DataSpace decimal(15,2),
	IndexSpace decimal(15,2),
 	TotalSize decimal(15,2),
 	PercentOfDB decimal(15,2),
 	DBSize  decimal(15,2))


	EXEC sp_msforeachtable @command1="insert into #temp(NbrOfRows, DataSpace, IndexSpace) exec sp_mstablespace '?'",
	 			@command2="update #temp set TableName = '?' where RecID = (select max(RecID) from #temp)"
	  
	UPDATE #temp 
	SET TotalSize = (DataSpace + IndexSpace), DbSize = (SELECT SUM(DataSpace + IndexSpace) FROM #temp)
	 
	UPDATE #temp 
	SET PercentOfDb = (TotalSize/DbSize) * 100
	
	declare @DBName varchar(128)
	select @DBName = db_name()
	
	UPDATE #temp 
	SET DBName = @DBName 
	 
             INSERT INTO Administration.dbo.dba_TableGrowth(DBName, RecID, TableName, NbrOfRows, DataSpace, IndexSpace, TotalSize, PercentOfDb, DBSize)
	SELECT * 
	FROM #temp
	ORDER BY TotalSize DESC
	 
	DROP TABLE #temp