Full-Text Search in SQL Server Express Won't Recognize Latest IFilters
- by Brandon King
I'm having difficulty getting full-text search working in SQL Server 2008 Express with Advanced Services. I have a table loaded with .DOCX files as varbinary(MAX) data that I want to use for a full-text catalog, but it doesn't seem to recognize the .DOCX format.
Here are the steps that I've taken...
Installed the latest Filter Pack 2.0
Exec sp_fulltext_service 'load_os_resources', 1
Exec sys.sp_help_fulltext_system_components 'all' (NOTE: .DOCX is not shown as a filter)
Building the full-text catalog fails to identify any key words
I initially thought there might be a conflict between x86 SQL Express and x64 Filter Pack on my Windows 7 machine, but I just tried it with everything x86 in a Windows XP virtual machine and got the same result.