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)

     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

CLOSE My_Cursor

DEALLOCATE My_Cursor