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