Could not find full-text index for database ID %d, table ID %d. Use sp_fulltext_table to deactivate then activate this index.

Details
Product: SQL Server
Event ID: 7606
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Could not find full-text index for database ID %d, table ID %d. Use sp_fulltext_table to deactivate then activate this index.
   
Explanation
The specified full-text index is unavailable.
   
User Action
Execute sp_fulltext_table with @action = ‘deactivate’. Then execute sp_fulltext_table with @action = ‘activate’. If you still receive this error, drop and recreate the full-text index.

Related:

Leave a Reply