Part I: Table Size Estimation

Select	l1o.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