SQL SERVER»ñÈ¡±íµÄ¿Õ¼ä·Ö²¼Çé¿ö

/********************************
¹¦ÄÜ£º»ñÈ¡±íµÄ¿Õ¼ä·Ö²¼Çé¿ö
**********************************/
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tablespaceinfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
create table  tablespaceinfo                         --´´½¨½á¹û´æ´¢±í
              (nameinfo varchar(50) ,    --ΪÆäÇëÇó¿Õ¼äʹÓÃÐÅÏ¢µÄ±íÃû¡£
               rowsinfo int ,     --±íÖÐÏÖÓеÄÐÐÊý¡£
        reserved varchar(20) ,    --±í±£ÁôµÄ¿Õ¼ä×ÜÁ¿¡£
               datainfo varchar(20)  ,    --±íÖеÄÊý¾ÝËùʹÓõĿռäÁ¿¡£
               index_size varchar(20) ,   --±íÖеÄË÷ÒýËùʹÓõĿռäÁ¿
               unused varchar(20) )   --±íÖÐδÓõĿռäÁ¿
delete from tablespaceinfo --Çå¿ÕÊý¾Ý±í
declare @tablename varchar(255)  --±íÃû³Æ
declare @cmdsql varchar(500)
DECLARE Info_cursor CURSOR FOR
select o.name 
from dbo.sysobjects o where OBJECTPROPERTY(o.id, N'IsTable') = 1
     and o.name not like N'#%%'  order by o.name
OPEN Info_cursor
FETCH NEXT from Info_cursor
INTO @tablename
WHILE @@FETCH_STATUS = 0
BEGIN
  if exists (select * from dbo.sysobjects where id = object_id(@tablename) and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  execute sp_executesql
         N'insert into tablespaceinfo  exec sp_spaceused @tbname',