Need help to perform FTS on this table..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Varun - 01 Mar 2006 13:48 GMT

Hello all,
I am working on a project and need some help. I am having an
application that uploads the data in the "resume" table and the content
of resume table is as follows:
<pre>

rid fileName docType resume_Title
document
1 ANewFile.doc doc ANewFile
0xD0CF11E0A1B11AE100.......
2 Sumi.doc doc Sumi
0xD0CF11E0A1B11AE100.......
3 succes2.doc doc succes2
0xD0CF11E0A1B11AE100.......
4 success1.doc doc success1
0xD0CF11E0A1B11AE100000.....
</pre>

I want to perform a Full-Text Search on the document column which is
containg MS-WORD documents. Can anyone help to learn how to do that.
I'd really appriciate the effort, if you can help me with the steps.
The only thing I know about FTS is that I need to install it as a
seperate service in the SQLServer.
Please help.
Thanks & Regards,
Varun Narang.

Reply to this Message

Hilary Cotter - 01 Mar 2006 16:22 GMT

Have a look at this link - http://www.indexserverfaq.com/blobs.htm

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hello all,
> I am working on a project and need some help. I am having an
[quoted text clipped - 22 lines]
> Thanks & Regards,
> Varun Narang.

Reply to this Message

Varun - 04 Mar 2006 13:36 GMT

Thanks Mr. Cotter,
That was really helpful. I must say, I couldn't find much better
explanation than that.
Thanks once again for great help.
Regards,
Varun Narang.

Reply to this Message

Varun - 04 Mar 2006 16:16 GMT

Thank you Hilary.
That was really helpful. I must say, I couldn't find much better
explanation than that.
Thanks once again for great help.
Regards,
Varun Narang.

Reply to this Message