We are using Full Text Search on our production SQL Server
(Active/Active Cluster, MSSQLSERVER EE).
Within the last week we have not been able to rebuild the FTC on any
database on one node/instance.  We get the following message:

I've created a couple of full-text indexes using the FT wizards and/or sample
code from BOL.  Everything appears to be correct and I've run a full
population on them without getting any errors.  However, when I run my
queries to test the results I get no rows returned.  When I ...

I see sqlserver2005 has no many languages which were announced.
For example I need arabic as the language for indexing and search. I dont
see it in the language list.No wordbreaker.
Any ideas?

I have a question about SQL Server 2000 Full Text Index.
I want to create a catalog in a field (varchar(255)), but I?m with 2
problems:
1. The characters of this field can have accent. But when I do a search

I have number of catalogs on my server. when i am clicking on the full text
catalogs section on the enterprise manager the enterprise manager is stucked
and i cant see any catalogs. anyone knows what is the problem? thanks!

I am trying to set up full-text indexing on my SQL Server 2000 instance
running on WIndows 2000 Server.  Every time I try to create a FT
catalog, I get the following message:
"The microsoft search service cannot be administered under the present

We're running a Windows 2000/2003 network.
On Servers running Windows 2003 with or without SP1 and SQL Server 2000 SP3a
or 4, we cannot create any full Text Search Catalogs.
Whatever login we try to use, if we try to create a new catalog, from

This may be an ancient query -but I have not found answers searching across
MS's WWW site or the wider internet.
I have
   SQL 7sp4 + combined security update for sql7sp4

I want to information about INDEXING? Why we creat index and how to creat
and where we can manage index? In SQL 2000 EM where we can see old indexes ?
regards,
Henrik

Is there a way to implement wildcard search like using LIKE operator to
implement in FullText Search using FREETEXT or CONTAINS?
For example Giving a key word, 'Mexico'  should fetch the records which
contains 'Mexicocity'

just a little question :
in full text search, in SQL Server 2000, how to enable accent-insentive?
for exemple : if I seize "tele", I want to have results with "télé", "tele",
"téle" and "telé"

Hey all,
I'm using full text indexing for keyword search capabilities for one of our
clients'. We needed to provide boolean search capability and hence I chose
containstable instead of freetext.

I did the following SQL Query.
set @sql = @sql + 'select distinct
        s.PrimaryKey,
        indx.rank, d.documenttype_id,

I have a query
SELECT DISTINCT Top 400  PFSchemaInstance_ID, 0 Rank, 0 CriteriaCount,
FromDate, pfSchemaInstance_ID FROM
PFLightningSearch_PersonProfileImpulse_Publish L  WHERE  CONTAINS (Text,

I've been googled and haven't found any soloution yet.  I'm getting the
following error while doing a CONTAINS query on a fulltext catalog.
Server: Msg 7342, Level 16, State 1, Line 1
Unexpected NULL value returned for column '[TextData].KEY' from the OLE