I have a table which has Full Text Search enabled on a couple of the
columns with automatic change tracking enabled. If I insert a new row
into that table, the new entry cannot be found using FTS, but all other
entries can be found OK. The only way I can get it to be found using
CONTAINS is if I force a Full repop.
Change tracking is enabled and after a bit of googling, I've also added
a timestamp column to this table. If I right click on the catalog under
"storage" the population status says "Processing notifications" however
it seems to stay in this state indefinitely, even though there are only
8000 rows in the table and I have only altered one of those rows since
the last full pop. I've even tried rebuilding the catalog from scratch.
Does anybody know what I'm doing wrong or why this might not be working?