sqlserver 自动重建库中所有表索引

ALTER PROCEDURE [dbo].[p_ReIndexing] (

@dbname varchar(50)

)

AS

SET NOCOUNT ON

DECLARE @tblname varchar(200), @execstring nvarchar(4000)

EXEC('

DECLARE defrag_cursor CURSOR FOR

SELECT

  ''['' + b.name + '']'' + ''.'' + ''['' + a.name + '']'' AS tblname

FROM '

  + @dbname + '..sysobjects a (nolock)

  INNER JOIN ' + @dbname + '..sysusers b (nolock)

   ON a.uid = b.uid

WHERE a.name NOT LIKE ''sys%'' 

 AND a.name NOT LIKE ''%sys%''

 AND a.name NOT LIKE ''%properties%''

  AND a.name NOT LIKE ''MS%''

  AND a.type = ''U''

GROUP BY ''['' + b.name + '']'' + ''.'' + ''['' + a.name + '']''')

OPEN defrag_cursor

  FETCH NEXT FROM defrag_cursor

    INTO @tblname

  WHILE @@FETCH_STATUS = 0

    BEGIN