Full-Text Search on Image Data Type Column in SQL Server 2000
Posted on 2003-10-26
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
(Covisible Solutions - a Customer Care Software & Document Management System company)