Indexing PDF files

Mark Hermans

unread,

Feb 6, 2003, 3:31:30 PM2/6/03

to

Hi,

A very short question.
Is it possible to index PDF Files ?

Mark

Hilary Cotter

unread,

Feb 6, 2003, 3:43:52 PM2/6/03

to

yes, but you have to store the PDF in the image column and have a docType
column (char, or varChar(3) or 4) with the contents being PDF or .PDF (case
insensitive).

Then you must have the Adobe iFilter installed on your machine.

To tell SQL Server that the contents of the row are your pdf you have to
issue a sp_fulltext_columns sp like this

sp_fulltext_column 'TableName' , 'ImageColumnName' ,
'add',1033,'DocumentTypeColumn'

also watch out for the PDF iFilter - check out this link for more info:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q323040

"Mark Hermans" <mark.h...@pandora.be> wrote in message
news:#xuMr6hzCHA.2736@TK2MSFTNGP09...

Andrew Cencini [MS]

unread,

Feb 6, 2003, 4:21:34 PM2/6/03

to

One clarification -- if you apply SQL 2000 SP3, the filtering facility now
correctly handles single-threaded filters. Applying SP3 and installing the
Adobe PDF IFilter, etc. will give you what I think you're looking for.

All the best,
--andrew

--

Andrew Cencini
Program Manager - SQL Server
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

"Hilary Cotter" <hil...@att.net> wrote in message
news:#m46oBizCHA.2736@TK2MSFTNGP09...

John Kane

unread,

Feb 7, 2003, 4:32:32 PM2/7/03

to

Good clarification, Andrew,
Is this now or soon to be documented in a FIX KB Article?
As any fix for this problem should be documented, IMHO.
Regards,
John

>.
>

Andrew Cencini [MS]

unread,

Feb 7, 2003, 4:39:14 PM2/7/03

to

I've forwarded the note to find out what the status is. I'm not sure how it
slipped through the cracks.

Thanks,
--andrew

--

Andrew Cencini
Program Manager - SQL Server
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

"John Kane" <jt-...@attbi.com> wrote in message
news:018d01c2cef0$6c0d0260$d7f82ecf@TK2MSFTNGXA14...

John Kane

unread,

Feb 13, 2003, 5:31:08 PM2/13/03

to

Andrew,
Once the KB is written and reviewed and ready to be published on
support.microsoft.com, it's be nice to have follow-up posting here that
there is in fact a publicly available KB article on this FIX in SP3 for the
single-thread issues with the PDF Adobe Ifilter.

Thanks,
John

"Andrew Cencini [MS]" <acen...@online.microsoft.com> wrote in message
news:u8QpRFvzCHA.1928@TK2MSFTNGP10...

Phil Revill

unread,

Apr 3, 2003, 11:08:21 AM4/3/03

to

This is very, very interesting.

Can you tell me where to get the pdf iFilter? Is a
download or a purchased product, or has someone written
one?

>.
>

John Kane

unread,

Apr 3, 2003, 1:26:10 PM4/3/03

to

Phil,
It's a free download. Although, now you might have to "register" at Adobe's
site to download any of their products... see
http://www.adobe.com/support/salesdocs/fa82.htm for info and download URL.

Regards,
John

"Phil Revill" <phil....@dssp.com> wrote in message
news:32ed01c2f9fb$3f5c5b40$7d02...@phx.gbl...