Full text search not working for pre-existing data on table after installing docx filter.However works for new records.
Thursday, September 30, 2010 7:11 PM
I have a strange issue. I have pre-existing data in my table with full text index defined along with catalog. I noticed that I did not have the docx filter ,so I installed the filter and performed the steps below. After installing the filter I added a couple of new records. I noticed that the full text search pulled up the new records matching the criteria but did not return any pre-existing records. Could you please let me know the issue.Please note – currently I am using sql 2008 , but also would like to verify the same in sql 2005 as well.
Also could you please verify the steps below for installation in sql 2008 and sql 2005 and with different architectures (Eg windows 2003/2008, 32bit, 64 bit etc)
This was tested on VM image on 64 bit architecture Windows 2008 R2, but I have to make sure that the same set up works on different OS since the client can have any version of OS.
1) Install docx filter from
3) For current database - EXEC sp_fulltext_service 'load_os_resources',1
4) Repopulate the index
a. Go to the table.
b. Right click Full-text Index – Start Full text population.
5) Restart the sql server service .
6) If sql 2005 – Sql full text Filter Daemon Launcher.
Please note that the full text is applied on columns of varbinary, text, varchar types only.
Monday, October 04, 2010 3:48 AM
Have you started a full population on the full-text index after you installed the .docx IFilter? If not, please start a full population and then re-run the query to see the result.
Full-Text Index Population
How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.