Update and solution...

The problem in this case proved to be the PATH variable..

Setting the PATH through Control Panel > System > Advanced System Settings apparently only changes the path for...

After finding this post:

http://social.technet.microsoft.com/Forums/sqlserver/en-US/e3e09cd5-ff38-4f9b-9724-832f9ba824df/full-text-search-of-pdf-files-in-a-file-table

I followed the advice and uninstalled Adobe iFilter11 and installed 9 instead.. after updating the path variable (to the iFilter) and a quick restart all...

For anyone stumbling upon this post, the fix for the 'docX' problem is to download the latest Ofice iFilters from here

Then reload the filters and restart the service..

EXEC sp_fulltext_service 'load_os_resources',1

EXEC...

Aha..!!

Just checked the docX filter a bit more carefully (using EXEC sp_help_fulltext_system_components 'filter' ) and it reads:

C:\Windows\system32\"C:\Program Files\Windows NT\Accessories\WordpadFilter.dll"

..instead of the correct path:

C:\Program Files\Windows NT\Accessories\WordpadFilter.dll

If I can work out how...

Not sure if this is useful information or not, but it appears that 'doc' files ARE being indexed.. just nit docX files. Hadn't noticed before as all the previous attempts...

Hi Howard..

Yes, the iFilters appear to be installed.. The iFilter for pdfs is C:\Program Files\Adobe\Adobe PDF iFilter 11 for 64-bit platforms\bin\PDFFilter.dll.

I've added this to the path environment list and also...

ok, slight clarification..

when running the command:

SELECT display_term, column_id, document_count FROM sys.dm_fts_index_keywords (DB_ID('test'), OBJECT_ID('documents'))

There are initially no entries as expected but after the first pdf / doc or whatever file is...

Ah Dan, thanks for the reply..

That is exactly what I would have done if it were not for our latest phone software.. it needs to run 2005 and as it...

Ok, here's a possible ray of hope for anyone following this thread..

http://www.dotnet-news.com/lien.aspx?ID=3958

is an article that (apparently) captures the output from the microsoft stemmer component.. however, for my...

Thanks for the idea Farrel,

I've played around a bit and, as you say the DIFFERENCE function does indeed yield good results for the inflected forms of most words. I'm not...

Thanks David, and nice code.

It takes me part of the way there I think and should be reasonably effiecient. It still leaves me a problem of users who enter 'runner'...

Thanks for the swift reply Kenneth,

The code you've written is very slick but doesn't really get to the root of the problem in that I don't actually know the exact...