To register IFilter packs with your SQL Server for binary text search

Note: 

Landmark supports text search of binary documents. However, your SQL Server may not be able to search certain types of documents. The following procedure explains how to check what document types your SQL Server supports and how to add IFilter packs for the support of additional document types.

  1. To check which document types your SQL Server supports, in the SQL Server Management Studio, run the following query:

    select document_type, path from sys.fulltext_document_types

    If a particular document type is not in the result set, then you will need to install the corresponding IFilter pack.

  2. If you need additional IFilter packs, download the IFilter pack from the appropriate site. For example, the sites for Adobe Reader 9, Microsoft Office 2007, and Microsoft Office 2010 are:

    • Adobe PDF iFilter 64 11.0.01 (64-bit): http://www.adobe.com/support/downloads/detail.jsp?ftpID=5542

    • Microsoft Office 2007 (32- and 64-bit): http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=20109

    • Microsoft Office 2010 (32- and 64-bit): http://www.microsoft.com/download/en/details.aspx?id=17062

  3. After you download and install an IFilter pack, execute the following commands in SQL Server Management Studio:

    exec sp_fulltext_service 'load_os_resources', 1;

    exec sp_fulltext_service 'verify_signature', 0;

  4. If the IFilter pack has a readme.txt, be sure to read it and follow its instructions.