Adding PDF indexing with Sql Server 2005

I am trying to use the full-text indexes with Sql Server 2005, and wanted to
index pdf files. I have downloaded and installed the Adobe PDF iFilter from
Adobe, and have tested it using the iFiltTst on a directory with PDF files.
It does index the pdf files.
I then moved the files into a sql server table into a varbinary(max) field.
I re-popualted the index, but it is not being indexed. Also, when I use the
"sp_help_fulltext_extensions" command, the ".pdf" extension does not appear.
Any suggestions on how to get this to work?
Steve
issue the following
sp_fulltext_service 'verify_signature', 0
sp_fulltext_service 'load_os_resources',1
bounce sql server and it should work (provided you have the PDF iFilter
installed).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steven Paplanus" <sapaplanus@.hotmail.com> wrote in message
news:u0j55Zc8EHA.208@.TK2MSFTNGP12.phx.gbl...
> I am trying to use the full-text indexes with Sql Server 2005, and wanted
to
> index pdf files. I have downloaded and installed the Adobe PDF iFilter
from
> Adobe, and have tested it using the iFiltTst on a directory with PDF
files.
> It does index the pdf files.
> I then moved the files into a sql server table into a varbinary(max)
field.
> I re-popualted the index, but it is not being indexed. Also, when I use
the
> "sp_help_fulltext_extensions" command, the ".pdf" extension does not
appear.
> Any suggestions on how to get this to work?
> Steve
>
|||This will work, but beware that making this change makes your SQL instance a
little less secure.
Be sure to read the documentation for these flags so you understand the
risk.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:efcPGQt8EHA.3700@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> issue the following
> sp_fulltext_service 'verify_signature', 0
> sp_fulltext_service 'load_os_resources',1
> bounce sql server and it should work (provided you have the PDF iFilter
> installed).
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Steven Paplanus" <sapaplanus@.hotmail.com> wrote in message
> news:u0j55Zc8EHA.208@.TK2MSFTNGP12.phx.gbl...
wanted
> to
> from
> files.
> field.
> the
> appear.
>