SQL Server 2005 - Script to Build all FullText catalog
-- SQL 2005 - Build all FullText catalog
DECLARE @Cur_CatalogName nvarchar(max)
DECLARE
My_Cursor CURSOR FAST_FORWARD FOR
SELECT name FROM sys.fulltext_catalogs
OPEN
My_Cursor
FETCH
NEXT FROM My_Cursor INTO @Cur_CatalogName
WHILE
(@@fetch_status = 0)
BEGIN
PRINT 'FullText Catalog: ' + @Cur_CatalogName
EXECUTE sp_fulltext_catalog @Cur_CatalogName, 'Rebuild';
EXECUTE sp_fulltext_catalog @Cur_CatalogName, 'start_full';
FETCH NEXT FROM My_Cursor INTO @Cur_CatalogName
END
CLOSE
My_Cursor
DEALLOCATE
My_Cursor
