Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

On a SQL Server 2008 server, we have a full text catalog in a database. The catalog is set to "track changes: automatic".

What can cause this to not work sporadically, so the index is not updated?

share|improve this question
up vote 1 down vote accepted

Could this be it?

"SET CHANGE_TRACKING {MANUAL | AUTO | OFF} Specifies whether changes (updates, deletes, or inserts) made to table columns that are covered by the full-text index will be propagated by SQL Server to the full-text index. Data changes through WRITETEXT and UPDATETEXT are not reflected in the full-text index, and are not picked up with change tracking."

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.