Indexing documents in SQLServer 2005

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.