SQL Server 2008 Full Text Search results

Question

I''ve a little problem while using SQL Server Full Text Search.

Let me explain,

• I've a table with a BLOB inside (a PDF file).
• I've created the full text index in that table like it should be.
• I've the PDF iFilter from Adobe.

BUT, when I put some files in my table and execute a search like:

SELECT *
FROM MyTable
WHERE FREETEXT(*, N'thank');

It only returns the columns from my table (well, that's what I asked, right?).

But I wanted to return the sentence where the word 'thank' was found. Is there any way to do this?

I've been fighting with this issue for almost 2 days...

Answer 1

Do you have any evidence that the PDF IFilter is working from within SQL Server at all? Just as a test put an MS Word 2003 doc in there and see if it gets indexed properly.