declare @id NVARCHAR(100)
create table #spt_space
( [name] NVARCHAR(50) null,
[rows] int null,
[reserved] NVARCHAR(50) null,
[data] NVARCHAR(50) null,
[index_size] NVARCHAR(50) null,
[unused] NVARCHAR(50) null
)set nocount on
declare c_tables cursor for
select name from sysobjects where xtype = 'U'
open c_tables fetch next from c_tables into @id
while @@fetch_status = 0begin /* Code from sp_spaceused */
insert into #spt_space ([name],[rows],reserved,data,index_size,unused)
EXEC sp_spaceused @id
fetch next from c_tables into @id
endSELECT * FROM(
SELECT *,CAST(REPLACE(reserved,'KB','') AS INT) AS reservedindex FROM #spt_space
) corder by c.reservedindex desc
drop table #spt_space
close c_tables
deallocate c_tables
|
本文转自温景良(Jason)博客园博客，原文链接：http://www.cnblogs.com/wenjl520/archive/2011/07/01/2095320.html如需转载请自行联系原作者