I am writing a stored procedure for my search box control. I found
this sample code which sets the @WORD1 to 'TBB-12' and searches 1
table for the information. I set the value to TBB-12 and specified to
look in the dbo.product_id. It did find the product id = TBB-12 on the

I'm new on FullText Search.
I need this in order to find part of words on 3 of my columns in table
(Table1(Txt1, Txt2, Txt3)
I've discovered the function CONTAINSTABLE(...) which brings me rank of

I have a sql server 2005 db which contains a full text catalog on  a
table, certain columns on that table have a words with hyphens in them,
the customer expects the results to come up when the search term
contains hyphens, but looks like the indexing service uses hyphens as

I am a novice on Full text search, never used it before.
I have a large number of word documents (.doc files) with different layouts
and contents where I need to extract some data to populate a database. The
documents are invoices. In the documents I would like to search for  ...

my full text queries have suddenly stop functioning,when I press execute tab,
its keep on saying "Executing query" for hours.Can any one tell me how to
resolve this problem.
I am using SQL server 2005.In the enterprise manager, I can see Full Text

I'm running SQL Server 2000 Developers Edition on my Windows XP workstation
(SP2)
I have configured Full text indexing on 1 table in my database.
Everything worked fine untill yesterday.

I have a table for storing text with different language (Chinese / English / Japanese.. etc) like this:
ID (int)
Lang (char(2))
Story (nvarchar(100))

I have an SQL Server 2005 database storing file names (millions), and I
currently use LIKE to search the database - most of the time I need to do
searches using a part of the file name. The search is very slow right now.
Will using a FullText index help with performance in this ...

I'm using a Contains clause for some data that's getting passed from
Reporting Services and I'm having trouble dealing with NULL, which creates a
"Null or empty full-text predicate." error.  
My first thought was to trap it using a coalesce or isnull as in

I want to write stored procedure,which will use FormsOF Inflectional,
BUT I am getting error,actually I dont know how to pass parameter in the
Inflectional query.
here it goes....

I want to use  database instead of FSDirectry or RAMDirectory.
I want to store indexes build by lucene in database (MySQL).
Can anybody suggest me how to do this?

I have a few databases with full text index in spanish. Every time I
try to do a backup of these databases, be it through SSMS or a script,
full or filegroup, backups never finish until I kill or stop the full
text indexing service. Once I stop it the backup finishes correctly.

This is my first attempt to write a sp using a full-text search.  It is a
straight forward search of a classified ad table where the search words can
be one or more words.  It can be a word like 'Harley' or a phrase like 'for
sale'.  The problem I am having is that I get an error ...