create table #t(name varchar(255), rows bigint, reserved varchar(20), data varchar(20), index_size varchar(20), unused varchar(20)) exec sp_MSforeachtable "insert into #t exec sp_spaceused '?'" select * from #t ORDER BY CAST(REPLACE(data,'kb','') AS INT) desc drop table #t
exec sp_MSforeachtable "insert into #t exec sp_spaceused '?'"
select * from #t ORDER BY CAST(REPLACE(data,'kb','') AS INT) desc
drop table #t