• You may want a script that recreates all the indexes.

    WITH ftCat AS (

    SELECT CatalogName = QUOTENAME(c.name), is_default, is_accent_sensitivity_on,

    owner = QUOTENAME(p.name COLLATE DATABASE_DEFAULT),

    path = LEFT(path, LEN(path) - CHARINDEX('\', REVERSE(path)))

    FROM sys.fulltext_catalogs c

    INNER JOIN sys.database_principals p ON p.principal_id = c.principal_id ),

    ftIdx AS (

    SELECT CatalogName = QUOTENAME(cat.name),

    TableName = QUOTENAME(sch.name) + '.' + QUOTENAME(tbl.name),

    ColumnName = QUOTENAME(col.name),

    IndexName = QUOTENAME(pk.name),

    ix.change_tracking_state_desc

    FROM sys.fulltext_indexes ix

    INNER JOIN sys.fulltext_catalogs cat ON cat.fulltext_catalog_id = ix.fulltext_catalog_id

    INNER JOIN sys.fulltext_index_columns ixc ON ix.object_id = ixc.object_id

    INNER JOIN sys.tables tbl ON tbl.object_id = ix.object_id

    INNER JOIN sys.schemas sch ON sch.schema_id = tbl.schema_id

    INNER JOIN sys.columns col ON ixc.object_id = col.object_id AND ixc.column_id = col.column_id

    INNER JOIN sys.indexes pk ON ix.object_id = pk.object_id AND ix.unique_index_id = pk.index_id

    )

    SELECT 'ALTER FULLTEXT INDEX ON ' + TableName + ' DISABLE;

    DROP FULLTEXT INDEX ON ' + TableName + ';

    GO'

    FROM ftIdx

    UNION ALL

    SELECT 'DROP FULLTEXT CATALOG ' + CatalogName + ';

    GO

    CREATE FULLTEXT CATALOG ' + CatalogName + ' IN PATH ' + QUOTENAME(ftCat.path, CHAR(39))

    + ' WITH ACCENT_SENSITIVITY = ' + CASE is_accent_sensitivity_on WHEN 1 THEN 'ON' ELSE 'OFF' END

    + CASE is_default WHEN 1 THEN ' AS DEFAULT' ELSE '' END

    + ' AUTHORIZATION ' + owner + ';

    GO'

    FROM ftCat

    UNION ALL

    SELECT 'CREATE FULLTEXT INDEX ON ' + TableName + '(' + ColumnName + ') KEY INDEX ' + IndexName + ' ON ' + CatalogName + ' WITH CHANGE_TRACKING ' + change_tracking_state_desc + ';

    GO'

    FROM ftIdx