查看数据库所有表占用空间大小

create table #temp_spaceinfo
(nameinfo varchar(50),rowsinfo int,reserved varchar(20),datainfo varchar(20),index_size varchar(20),unused varchar(20))

declare @name varchar(500)
declare cur cursor for
select name from sysobjects where xtype='u'order by name
open cur
fetch first from cur into @name
while @@fetch_status=0
begin
insert into #temp_spaceinfo
exec sp_spaceused @name

fetch next from cur into @name
end

close cur
deallocate cur

select * from #temp_spaceinfo order by cast(left(ltrim(rtrim(reserved)),len(ltrim(rtrim(reserved)))-2) as int) desc