1 if OBJECT_ID (‘tempdb..#temp‘) is not null 2 drop table #temp 3 go 4 CREATE TABLE #temp 5 ( 6 name VARCHAR (100), 7 rows INT , 8 reserved varchar (20), 9 data varchar (20),10 index_size varchar (20),11 unused varchar (20),12 time datetime default getdate()13 14 )15 DECLARE @tablename VARCHAR( 100)16 DECLARE @sql VARCHAR( 500)17 DECLARE @str VARCHAR( 100)18 DECLARE tablecursor CURSOR19 FOR20 SELECT name21 FROM sys.tables22 WHERE type_desc = ‘USER_TABLE‘23 OPEN tablecursor24 FETCH NEXT FROM tablecursor INTO @tablename25 WHILE @@fetch_status = 026 BEGIN27 SET @str = @tablename28 SET @sql = ‘insert into #temp(name,rows,reserved,data,index_size,unused) EXEC sp_spaceused [‘ + @tablename + ‘]‘29 EXEC(@sql )30 FETCH NEXT FROM tablecursor INTO @tablename31 END32 CLOSE tablecursor33 DEALLOCATE tablecursor34 35 36 SELECT * FROM #temp 37 where rows <> 038 order by [rows] desc39 40