--查询出有数据的表
CREATE TABLE #temp
(
TableName NVARCHAR (128), /*表明称*/
RowsCnt VARCHAR (11), /*数据的行数*/
ReservedSpace VARCHAR(18), /*预留空间*/
DataSpace VARCHAR(18), /*数据空间*/
CombinedIndexSpace VARCHAR(18), /**/
UnusedSpace VARCHAR(18) /*没用空间*/
)
EXEC sp_MSforeachtable'INSERT INTO #temp (TableName, RowsCnt, ReservedSpace,DataSpace, CombinedIndexSpace, UnusedSpace) EXEC sp_spaceused ''?'', FALSE'
SELECT TableName, RowsCnt,ReservedSpace, DataSpace, CombinedIndexSpace, UnusedSpace
FROM #temp where RowsCnt<>0
ORDER BY TableName