Question

LAKSHMI NARAYANA REDDY.L on Thu, 29 May 2014 07:24:16


hi all,

we are created table and enabled fulltext search index , inserted .txt file into table and .pdf file into table.

i'm able to retrieve data from using below syntax

SELECT * FROM Doc WHERE contains(*,'Citibank')

i'm able to retrieve data from .txt file, but unable to retrieve data from .pdf file, please suggest what are the steps  i need to follow to get pdf file word results as well.



Thanks & Regards LAKSHMI NARAYANA REDDY.L


Sponsored



Replies

Erland Sommarskog on Thu, 29 May 2014 09:07:36


Support for PDM is not installed by default, but you need to get an iFilter from Adobe. My first hit on Google was this blog post from Damian Zapart, which includes both the download and instructions:
http://dzapart.blogspot.se/2012/04/full-text-search-with-pdf-in-microsoft.html