CREATE TABLE #t
(
name VARCHAR(255),
ROWS BIGINT,
reserved VARCHAR(20),
DATA VARCHAR(20),
index_size VARCHAR(20),
unused VARCHAR(20)
)
EXEC sp_MSforeachtable “insert into #t exec sp_spaceused ‘?’”
SELECT * FROM #t ORDER BY name
DROP TABLE #t
直接复制执行就可以了