I am having problems with Fulltext search on SQL Server 2008 R2. Basically I use CONTAINSTABLE and all works well with my tables but for some reason fails to return rows on one of the tables I am searching in.
I tried recreating the catalog and even recreating the table but no luck. Could this be a corrupt catalog or database?
Recreating the database from scratch through scripts sorted this out. The database must have been corrupt.