伊图教程网[www.etoow.com]
http://www.etoow.com/html/2008-04/1207106476.html
insert into tmp (name,rows,reserved,
data,index_size,unused) exec sp_msforeachTable @Command1="sp_spaceused '?'"--sp_spaceused 't_vehicle'
select * from tmp order by data desc
drop table tmp
如何查看SQL Server 2000数据库每个表占用的磁盘空间
'http://www.etoow.com/html/2008-04/1207106476.html