To see sizes of all tables in SQL 2005 use this:

DECLARE @tableName VARCHAR(1000);

CREATE TABLE #AllTables

(

row_num INT IDENTITY(1, 1),

...