>>Hi everybody,
>>
>>I'm trying to find a script that would list size of all database objects. I think it was posted here before, but I'm unable to find the thread.
>>
>>Thanks in advance.
>
>Take a look at
>http://www.mssqltips.com/tip.asp?tip=1629

I just found also

SELECT CASE WHEN (GROUPING(sob.name)=1) THEN 'All_Tables'
   ELSE ISNULL(sob.name, 'unknown') END AS Table_name,
   SUM(sys.length) AS Byte_Length
FROM sysobjects sob, syscolumns sys
WHERE sob.xtype='u' AND sys.id=sob.id
GROUP BY sob.name
WITH CUBE

at http://blog.sqlauthority.com/2006/11/10/sql-server-query-to-find-byte-size/