IF EXISTS (SELECT OBJECT_ID('tempdb..#ALL_TABLE_SIZES')) DROP TABLE #ALL_TABLE_SIZES CREATE TABLE #ALL_TABLE_SIZES ( TABLENAME NVARCHAR(MAX) NOT NULL ,SIZEINMB INT NOT NULL ) EXECUTE sp_MSforeachdb 'USE [?]; INSERT #ALL_TABLE_SIZES SELECT DB_NAME() + ''.'' + T2.name + ''.'' + T0.name ,SUM(T1.reserved_page_count*8.0/1024) FROM sys.objects T0 JOIN sys.dm_db_partition_stats T1 ON T0.object_id = T1.object_id JOIN sys.schemas T2 ON T0.schema_id = T2.schema_id WHERE [type] = ''U'' AND T1.index_id <= 1 GROUP BY DB_NAME() + ''.'' + T2.name + ''.'' + T0.name ' SELECT * FROM #ALL_TABLE_SIZES ORDER BY SIZEINMB