Creating FullText Index on Docx files in a FileTable

Question

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

Answer 1

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