Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Full text search not working for pre-existing data on table after installing docx filter.However works for new records.

שאלה 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
     
     
    Sign In to Vote
    0

    Hello All,

     

    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

    2)       http://www.microsoft.com/downloads/en/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC&displaylang=en

    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.

    • Moved by Tom Phillips Friday, October 01, 2010 1:39 PM Possibly better answer from TSQL forum (From:SQL Server Database Engine)
    • Moved by KJian_ Monday, October 04, 2010 3:46 AM (From:Transact-SQL)
    •  
     

All Replies