Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 1 down vote accepted

Could this be it?

http://msdn.microsoft.com/en-us/library/ms188359.aspx

"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
add comment

Your Answer

 
discard

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.