create
table
#test(
name varchar ( 50 ),
rows int ,
reserved varchar ( 20 ),
data varchar ( 20 ),
index_size varchar ( 20 ),
unused varchar ( 20 )
)
set nocount on
insert into #test
EXEC sp_MSforeachtable @command1 = "sp_spaceused ' ? ' "
select * from #test order by cast ( replace (reserved, ' KB ' , '' ) as int ) desc
drop table #test
name varchar ( 50 ),
rows int ,
reserved varchar ( 20 ),
data varchar ( 20 ),
index_size varchar ( 20 ),
unused varchar ( 20 )
)
set nocount on
insert into #test
EXEC sp_MSforeachtable @command1 = "sp_spaceused ' ? ' "
select * from #test order by cast ( replace (reserved, ' KB ' , '' ) as int ) desc
drop table #test