I have a SQLServer 2005 database and store documents in a table. I have installed the index and it works fine. My problem is that it does not index pdf documents, Office 2007 documents and so on.
Does anyone have a clue on how to solve this?
I have installed the Adobe ifilter 6 but how do you tell SQLServer this?
Is there an add method for the table that contains the filters?
Hi Robert,
Please check the following link:
http://msdn2.microsoft.com/en-us/library/ms175058.aspx
Try the following steps on your SQL Server Instance
sp_fulltext_service 'load_os_resources',1. This command tells the Microsoft Search Service to load OS specific wordbreakers, stemmers, and such.
sp_fulltext_service 'verify_signature', 0. Do not verify that the binaries are signed.
Hope this helps.
Thanks
Arpita
|||You might also check whether the MSSearch service has been started or up and running. Also check the SQL error log for any sort of fulltext indexing related errors.
