Part I: Table Size Estimation

Selectl1o.name,

        (SELECT i.rows
 FROM sysindexes i
 WHERE i.id = l1o.id 
   AND  i.indid In (0,1)) AS Row_Count,

(SELECT Count(*)
         FROM sysColumns c
 WHERE   l1o.id = c.id )as Num_Cols,

(SELECT  Sum(fdc.length) 
  FROM sysColumns fdc
  ,systypes   fdt        
   WHERE fdc.xtype     = fdt.xtype
    AND fdt.variable  = 0
    AND l1o.id        = fdc.id
  GROUP BY l1o.id) as Fixed_Data_Size,

(SELECT Count(*)
         FROM sysColumns vdc
         ,systypes   vdt
 WHERE   l1o.id = vdc.id
           AND   vdc.xtype     = vdt.xtype
           AND   vdt.variable  = 1)as Num_Variable_Col,

ISNULL(
    (SELECT  Sum(vdc.length) 
  FROM sysColumns vdc
  ,systypes   vdt        
   WHERE vdc.xtype     = vdt.xtype
    AND vdt.variable  = 1
    AND l1o.id        = vdc.id
  GROUP BY l1o.id),0) as Max_Var_Size

FROM sysobjects l1o

WHERE(l1o.xtype = 'u') 
  AND(l1o.type = 'u')

Order by l1o.name