full-text-searchdocxsql-server-2012fulltext-index

Creating FullText Index on Docx files in a FileTable


I'm working on a document storage. Therefore I plan to use SqlServer 2012 with file tables. Now after some tests it seems like the SqlServer only indexes doc and not docx files.

I also installed the Microsoft Filter Pack 2.0.

Does somebody know how to get a docx support ? Perhaps there wold also be a way to get pdf support ??

Many Thanks in advance Boas


Solution

  • Finally someone posted me the solution. I post the solution to my own question because i think someone may have similar problems

    Install the Microsoft Filter Pack 2.0

    than

    EXEC sp_fulltext_service 'update_languages'; 
    EXEC sp_fulltext_service 'load_os_resources', 1;
    EXEC sp_fulltext_service 'restart_all_fdhosts';
    

    After installing the filters, run this to refresh the list. EXEC sp_fulltext_service 'update_languages';

    You will also likely need to refresh the filters and restart the FTS service launcher: EXEC sp_fulltext_service 'load_os_resources', 1; EXEC sp_fulltext_service 'restart_all_fdhosts';

    Finally, you’ll need to do a complete rebuild/refresh of any existing full-text indexes (see ALTER FULLTEXT INDEX) to use the new filters.

    s. SqlServer Forum