Solved

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

Posted on 2003-10-26
3
234 Views
Last Modified: 2008-03-10
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)
0
Comment
Question by:dippies
3 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 250 total points
ID: 9623181
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now