I have an application I wrote that imports files into an image column in a
table. I have fulltext search setup on that table and it works great.
A problem I have is with scanned PDF documents that have not had OCR
performed on them. Is there an ifilter that can perform OCR on ...

There are some conflicting reports about this on the web, but as best as I
can tell FREETEXTTABLE includes stemming and thesaurus features but not
SoundEx abilities. I would appreciate any help on using FREETEXTTABLE and
SoundEx together in a query, particularly in regards to ...

Assuming I decide to keep my images in the file system (and the associated
text in sql), what's the best way to give access to a sql-based win app?
I can't give direct access to the folder, and can't think of a nice way for
sql server to deliver or accept the images.  Is a web ...

I have a FTcatalog on a table called "products" where I'm indexing
"product_id", "product_name", "product_description"
I'm parsing a search box in a form and splitting on the spaces to
dynamically create the query, so someone my type in "Bob&Roy Video"

Hey Hilary,
Mike from microsoft.public.sqlserver.programming told me to talk to
you about my question. Here's my original post:
I'm looking for some information about storing BLOBs in SQL. A bit of

I have installed SQL Server 2005 Express Edition with Advanced Services
and I tried to process a full-text search on a varbinary or image
column. I insert in this column ppt-files.
But it returns always 0 rows, although I searched some words that are

does anyone know how to search for Tab or other ascii characters (like
carriage retrun, line feed, etc) within a string (either varchar, or
text). i'm using sql 2000..
Also i was looking for some resources on Full text causing blocking on

-We have a 2 node windows 2003 enterprise edition cluster (S01 and S02).
-2 sql servers running in 2 different virtual servers (V01 and V02).
-The V01 SQL Server's preferred node is S01 and the V02 SQL Server's
preferred node is S02.

SQL Server fulltext resource is deleted from SQL cluster resource. When I add
resource from clusadmin tool the resource is not coming online its failing
any idea why this is not coming online?
its on SQL2000 and windows2000

I am currently using the third party product "SQL Turbo" on SQL Server
2000 to archive this:
I have a table:
id   DocText   DocScore

Howdy,
We have a SQL 2005 std server running on Windows 2003.  
We are having an issue where it looks like the full text service is locking
up.  In the activity monitor we will start to see processes waiting on

Hello, everybody!
I have just one question. And I hope someone will answer me. So, I need to
figure it out, how you can transfer your tables (containing data) from SQL
Server 4 to SQL Server 5 that you have THE SAME language settings. Does SQL

In SQL Server 2005 I can use full text searching on a varbinary(max)
column containing a Word document (for example).  When I return the
results of the search, I would like to return a snippet of the text
which matched the query to give my users some idea of why that document

We have 2 boxes running clustered windows enterprise OS 2003, SQL server 2000
sp4 in clustered mode.  Everything runs fine, except when we do a failover of
sql to the secondary node, full text indexing will not index.  The properties
come back with an item count of 1 instead of ...

I have some problems when searching using contains with multiple words.
A exemple: I have records with keyword bell and some othe with "bell pepper"
(including quotes)
Is it possible to sort records with the bell only keyword before the bell