Suddenly many queries to my SQL Server 2005 database are failing with this SQL error:
The execution of a full-text query failed. "The content index is corrupt.
Anyone know of a fix?
views:
198answers:
1
+1
Q:
SQL Queries failing with: The execution of a full-text query failed. "The content index is corrupt."
+2
A:
It sounds as though you may need to rebuild the Full Text Catalog:
How to: Rebuild a Full-Text Catalog (SQL Server Management Studio)
You may also find the following reference useful.
Full-Text Catalog and Index How-to Topics (Full-Text Search)
John Sansom
2009-08-01 13:54:12
If you happen to be running SQL Management Studio Express (like I am) the full-text stuff doesn't appear in the menus, so you can run this command: `ALTER FULLTEXT CATALOG catalog_name REBUILD`
JerSchneid
2009-08-03 14:59:37