Full-Text Search on Image Data Type Column in SQL Server 2000

dippies
dippies used Ask the Experts™
on
I have a table with a Column [Logo] which is of image data type. I also have a binding column associated with the Column [Logo] for holding the data type I store in the Logo column.

I have used ADO Stream object to store DOC files in the image-type column and the binding column has value - '.doc'

I want to search the document which is stored in the image column by specifying some keywords. Please note that I have enabled Microsoft Search and have created FUll-Text Indexes. What I basically need is a File-Content Search from the file data stored in SQL Server in an image data type. (I do not want to use Indexing Service directly).

How can I do that? Can anybody please help me in this regard?

Thanks & Regards
Dipayan Sarkar
(Dipayan@covisible.com)
(Covisible Solutions - a Customer Care Software & Document Management System company)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2004
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial