遍历数据库中所有表的空间使用情况

Create Table #temp(name varchar(100),
rows int,
reserved varchar(100),
data varchar(10),
index_size varchar(100),
unused varchar(100)
)

Declare @name Nvarchar(20)
Declare @sql Nvarchar(2000)
Declare cur1 Cursor
 For Select NAME From sysobjects where xtype='u' Order by name
Open cur1
Fetch NEXT  From  cur1 Into @Name
While (@@FETCH_STATUS=0)
BEGIN
 SELECT @sql='EXEC sp_spaceused N'''+ @name +''''
 Insert Into #temp Exec sp_executesql @sql
 Fetch Next From  cur1 Into @Name
END
Close Cur1
Deallocate cur1
Select * From #temp
Drop table #Temp