Full text search - change tracking not working - help!

Full text search - change tracking not working - help!

Post by Nick Gilbe » Thu, 14 May 2009 17:04:17


Hi,

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?

Thanks,

Nick...
 
 
 

Full text search - change tracking not working - help!

Post by Simon Sabi » Wed, 24 Jun 2009 07:19:37


Hello Nick,

What version of SQL Server?


Simon Sabin
SQL Server MVP
http://www.yqcomputer.com/