Re: Thesaurus Problem

Hi,

Just for information, closing and reopening Management Studio does not impact MSFTE service. You have to restart it in Services Management Console but it would have the same effect as rebooting your system (as you tried before).

--
Jean-Pierre Riehl


"Organic Man" <davidmcmillin@xxxxxxx> wrote in message news:1188272200.321569.78670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Aug 27, 10:49 pm, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
Did you save your thesaurus file with Unicode encoding? After SP 2 it must
be saved as a Unicode file.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"Organic Man" <davidmcmil...@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.


Hi Hilary,

Yes, I saved as unicode and double checked to be sure.

Are there any specific instructions for restarting MSFTESQL service,
other than closing and reopening Management Studio?

Does the full-text catalog need to be updated?


.

Loading