Some people are saying that  the only way to do a accent insensitive full
text search under SQL 200 is to replace mssearch with the version that comes
with Share Point Server.  Is this true or is ther another way?  If it is true
how are you supposed to send this to clients as not ...

Dear Friends,
When deploying the application I send a back up of the data base to be
restored on clients place.
there is a table in the database which a has FullText Index associated with

I am running into some wired problem with nvarchar(4000).  When I insert the
chinese characters, the text got cut off.  The following two sections shows
what happen, the first chinese section is what is ended up in the database,
the second section (separate by ...

My full text queries on a columns containing japanese text return strange
results.
- OS is Windows 2K Server (english) with Japanese support as default locale
- SQL Server 2000 english with Japanese collation.

Hi
I would like to know if solution a is faster than b:
a) Fulltext index on theese columns x nvarchar(250), y nvarchar(250),
z nvarhar(4000)

I have a customer that is complaining of poor performance when doing
searches against the FTS catalog during the day.
I believe what is happening is that the indexing process is taking place at
the same time as their searches.

I have FTS enabled on a number of columns on a SQL 7 database table, and
today for the first time I've had a strange result for a search term. The
term does not exist, and has never existed, in the column I'm querying, and
yet using CONTAINS(QuickSearch,'"0130606219"') as the ...

In Windows Sharepoint, I can't get the catalogs to build either manually or
by using the Sharepoint Central admin console. They have between 1-8 items,
and are never larger than 1 mb, even though the content is > 3 GB!
This is on a SQL 2000 Ent. running on a 2-node A-A cluster; ...

SQL Server 2000 SP3
(WIN NT/2000/XP)
Can somebody please explain how I can overcome the
following (what looks to be) limitation in SQL Server's

I'm trying to create a search engine for my Web Site using Indexing
Service. The content is stored in text files in UTF8 Encoding (arabic
text).
The search utility works well on my local server but it throws an

   I am trying to implement a FullText search for a table which contains
translations for many different languages. However, different languages
utilized different word breaker for the FullText search to work properly for
that language but I can only assign a single word breaker to ...

Is it possible to create a second FT-INDEX for the same table?  I want to
index different fields in each one to use it in different areas.
Alternatively, is it possible to do a FT search on MULTIPLE fields in an
Index?   I know that the FREETEXTTABLE can only do it on either one ...

I have the following:
     SELECT jobTitle from position where FreeText(jobDescription,'sales and
ccna') order by JobTitle DESC
This gives me 11 hits

I am using SQL Server 2000 on Windows 2000 server. Here is my problem:
@String = 'word1word2word3word4word5' - This value is passed to Stored
Procedure from the script.
Column1 in a table1 has many rows with "words" . One row in this column1

I want to use SQL 2005 FT to search on web page I crawled from web.  The
page can be Chinese, English or Chinese/English(Chinese article with English
phrase in it).
First question is that what language word breaker I should choose. Does