SET NOCOUNT ON;
DECLARE @table_name NVARCHAR(100);

CREATE TABLE  #result
(
   name varchar(100)
  , rows varchar(100)
  , data  varchar(100)
  , reserved varchar(100)
  , index_size varchar(100)
  , unused  varchar(100)
)

DECLARE cur_table CURSOR  for
       SELECT name
         FROM sysobjects
         WHERE type ='U'
         ORDER BY name

   OPEN cur_table;
   FETCH NEXT FROM cur_table INTO @table_name
   WHILE @@FETCH_STATUS = 0
      BEGIN
          insert into #result
            exec   sp_spaceused @table_name
          FETCH NEXT FROM cur_table INTO @table_name;
      END

   CLOSE cur_table;

DEALLOCATE cur_table;

SELECT *
FROM #result;

DROP TABLE  #result;
GO

먼저 감사합니다.

상당한 도움이 되었군요,