CREATE TABLE #TempTable
( [Table_Name] varchar(256),
Row_Length int
)
DECLARE @Command1 varchar(1000)
SELECT @Command1 = 'sp_msforeachtable ''select "?" TableName, sum(a.length)length from syscolumns a where a.id=object_id("?")'''
INSERT INTO #TempTable EXEC (@Command1)
SELECT * FROM #TempTable
DROP TABLE #TempTable