查看临时表空间

-- 查看系统所有表占用的空间情况
create table tmpspace
(Fname varchar(50),
Frows int,
Freserved varchar(50),
Fdata
varchar(50),
Findex_size varchar(50),
Funused
varchar(50));

insert into tmpspace
(Fname,Frows,Freserved, Fdata,Findex_size,Funused)
exec sp_msforeachTable
@Command1="sp_spaceused '?'"

select * from tmpspace where Fname like
'TMP%' order by Fdata desc

drop table tmpspace