@lowell,

i tried using your code .

create table ##tmp (TableName varchar(40),DefinedRowSize int)

sp_msforeachtable 'INSERT INTO ##TMP Select ''?'' As TableName, SUM(C.Length) as Length from dbo.SysColumns C where C.id =...