Sql-server – What can cause SQL Server Full Text Indexing automatic change tracking to stop working

full-text-searchsql server

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?

Best Answer

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."

Related Solutions

Sql-server – How to detect if full text search is installed in SQL Server

I like SELECT over PRINT

So here is my take on this

SELECT 
    CASE 
         WHEN 
             FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1 
         THEN 
              'INSTALLED' 
         ELSE 
              'NOT INSTALLED' 
    END IsFullTextInstalled

Sql-server – How to find the name of an existing full text catalog in SQL Server 2008 Express

You can just do the following:

SELECT * FROM sys.fulltext_catalogs

This will return the catalog names and should give you what you need.

Best Answer

Related Solutions

Sql-server – How to detect if full text search is installed in SQL Server

Sql-server – How to find the name of an existing full text catalog in SQL Server 2008 Express

Related Topic