Re: Thesaurus Problem

Hi ,

Go back to the begining, Let's try the empirical way.

Can you create a table with a varchar(max) column, for example, populate it with 'run' and 'jog' terms.
Then create a Full-Text Index, forcing indexation language.

CREATE FULLTEXT INDEX on AnotherTryTable
( [Description] LANGUAGE 1033)
KEY INDEX PK_ThePK
ON NewCatalog

Start with a fresh tsENU.xml file and ensure comments tag <!-- --> are removed.
Try to search against 'run' or 'jog' and tell us your results.

--
Jean-Pierre Riehl
http://blog.djeepy1.net
http://www.bewise.fr




"Organic Man" <davidmcmillin@xxxxxxx> wrote in message news:1188250168.087879.56150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am trying to get the full-text search thesaurus to work in Sql
Server 2005 Express edition. I live in the USA so I assume the
tx.ENU.xml is the appropriate file to modify. I used Notepad to
modify the tx.ENU.xml file and saved as unicode:

<XML ID="Microsoft Search Thesaurus">

<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
<sub>littre</sub>
<sub>leydig</sub>
</expansion>
<replacement>
<pat>NT5</pat>
<pat>W2K</pat>
<sub>Windows 2000</sub>
</replacement>
<expansion>
<sub>run</sub>
<sub>jog</sub>
</expansion>
</thesaurus>

</XML>

I closed Management Studio and reopened to allow MSFTESQL service to
restart. Then I ran these queries:

SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, 'littre') *** returned 3 rows ***

SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, 'leydig') *** returned 169 rows ***

SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, ' FORMSOF(THESAURUS, littre) ') ***
returned 6 rows ***

Thus the Thesaurus does not seem to be working since it should have
returned at least 169 rows. I rebooted my entire system to make sure
Sql Server is starting fresh.

Any help in sorting this out will be greatly appreciated.


.

Loading