Solved

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

Posted on 2003-10-26
3
271 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 250 total points
ID: 9623181
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Display Date and Time 7 48
Failover Cluster Primary Nodes Current Vote = 0 5 34
What does "Between" mean? 6 44
Begin Transaction 12 25
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

734 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