Full text search in docs in a table possible?

[fmientjes]

In a table there are documents like Word / PDF documents or a reference to external documents.
Can I use full text search for searching inside those documents as well?
If not, is there an alternative?

Thanks,
Frans

 

[dcpking]

If you are running v2000 or later, and if the text is actually within the tables, in the correct field types (see manual or online help) then you can use SQL Server for full text searching.

However, if the items are held in binary form (eg as .pdf files within a binary BLOb) or held outside the database, then you will not be able to search within them.

Instead, try getting someone to create a program that reads these external documents and creates an index for you. The index can then be held within SQL Server and accessed there ...

 

[VitoMark]

Did you already received a solution for this problem?
I've uploaded documents (.DOC) with ADODB.stream into an SQL-table (not external).
I've added the table to a catalog and populated the catalog
I've used a column with the extension of the document
But my Contains-query always returns 0 rows.
Any idea?

 

[fmientjes]

No, I have not found a solution for this.
It seems that there needs to be an external tool to index everything.
Maybe SQL 2005?

 

[mrdenny]

It most certenitly is possible. Check the forums. We had a thread on this a couple of weeks ago. SQL can easily be setup to index word docs and excel workbooks. PDFs can also be done, it's just a little harder. If I can find the thread I'll post it in here.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[mrdenny]

Here is the prevous thread on this topic thread183-1110526.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)