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?
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 ...
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?
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)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.