ALTER PROCEDURE P_ReIndexDatabases_UpdateStats
AS
Declare @sql varchar(max)
DECLARE @MyTable VARCHAR(255)
DECLARE myCursor
CURSOR FOR
SELECT TABLE_NAME
FROM information_schema.tables
WHERE table_type = 'base table'
OPEN myCursor
FETCH NEXT
FROM myCursor INTO @MyTable
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Reindexing Table: ' + @MyTable
SET @sql='ALTER INDEX ALL ON ['+ @MyTable +'] REBUILD WITH (ONLINE=ON)'
--PRINT @SQL
EXEC (@SQL)
FETCH NEXT
FROM myCursor INTO @MyTable
END
CLOSE myCursor
DEALLOCATE myCursor
EXEC sp_updatestats
No comments:
Post a Comment