SQL 2005 Full text indexing seems to stem "best" to "good" when using
CONTAINSTABLE(FORMSOF(INFLECTIONAL.  Is there anyway that I can confirm
whether this mapping is due to the SQL 2005 English dictonary, and whether
this entry is going to be removed, or if there is a work around ...

Hi, I am trying to implement a global full text search on our SQL
Server. Our app has several entities that are stored in the DB. I would
like to be able to search for 'John Doe' and get results in all types
of entities. Problem is:

I have to implement Search engine for one website,which will be capabale of
finding text from HTML,DOcs,and Db,
For HTML and DOC search I am currently using Index server for FREE TEXT
SEARCH.

How can I get and install a full Thesaurus into SQL Server 2005 CTP?
Thanks in advance!
Wayne

can anyone tell, is there anyway to reinstall/repair full-text without
having to actually uninstall and resintall the whole Sql Server?
Thanks in advance,
- Arthur Dent.

I've just restored a database from a backup, usually I have to correct the
path of the fulltext index in master.sysfulltextcatalogs after doing this,
but now sysfulltextcatalogs is empty and has no entries. When I right click
the table with the fulltext index I can see that it ...

I am having a problem with fulltext search whereby it always returns no
data. I have enabled full text search on the table and successfully
created a catalogue, which according to the event log has been
populated.

I have a commerce server database that uses a full text index to search
product numbers and descriptions.  My issue is that some of my product
numbers contain single characters, "EMT 1" for example, and the Contains
clause does not seem to treat this phrase as an exact match ...

What is the meaning of the "paused" status of a catalog? What is still
working and what isn't?
Thanks.

Hello,  I recently posted this question on the WSS group, and it was
recommended that we post the question here, since WSS uses the SQL Server
F/T engine.
We have WSS 2003 running on a SQL Server 2000.  WSS.  We tested F/T searches

I have a table like this:
CREATE TABLE T1(
C1 int identity(1,1) PRIMARY KEY,
C2 NVARCHAR(50))

I have two databases on separate servers - db1 & db2.  
I use DTS to copy the tables from db1 to db2 overnight.  Then I want to
recreate the fulltext catalog on one of the tables in db2 using a SQL Server
Agent job to run sp_fulltext_table:

Has anyone ever used or have any experience with Product called SQL Turbo,
is a replacement for MS DTS claims to process indexing 100x faster, much
more efficient than native FTS tools  the tool is out at
http://www.imceda.com

I know that with background updates the FTI is updated incrementally as
inserts and updates which affect the indexed column occur.  How can I tell if
an FTI on a column has been set for background updates?  
Also, do you know if there is a performance downside to having background ...

I need an article to learn customization of FTS for other languages.
Thanks in advance,
Leila