MS SQL Server 2000中查询数据库每个表占用磁盘空间情况

CREATE TABLE TMP
(name varchar(50),
rows int,
reserved varchar(50),
data varchar(50),
index_size varchar(50),
unused varchar(50))
GO

INSERT INTO tmp (name,rows,reserved,data,index_size,unused)

EXEC sp_msforeachTable @Command1="sp_spaceused '?'"

SELECT * FROM tmp ORDER BY rows desc ,data DESC

DROP TABLE tmp