Re: Thesaurus Problem

Hi,

Can you provide us full DDL you used to create full-text catalog and index ?

Hold on, do not despair !

Jean-Pierre.


"Organic Man" <davidmcmillin@xxxxxxx> wrote in message news:1188385539.078829.282070@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Aug 28, 9:30 pm, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
oops try this:

sp_configure 'show advanced options',1'
Reconfigure with Override
GO
sp_configure 'default full-text language'
GO

It looks like you need to edit tsenu.xml.

--

[...]

Hilary,

Thanks for your patience and assistance.

I edited tsenu.xml with Notepad as follows:

<XML ID="Microsoft Search Thesaurus">

<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
<sub>Leydig</sub>
<sub>leydig</sub>
<sub>littre/sub>
</expansion>
<expansion>
<sub>vagus</sub>
<sub>pneumogastric</sub>
</expansion>
</thesaurus>

</XML>

In the save options, I was offered four formats: ANSI, Unicode,
Unicode, Big Endian, and UTF-8. I chose Unicode.

The new edited ts.enu.xml file is located in the MSSQL.1/MSSQL/FTData
folder. I also placed a copy in MSSQL.2/MSSQL/FTData.

I rebooted my system (Vista) and reopened Management Studio on the
Developer's Edition of Sql Server 2005.

I ran the following queries:

SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, 'littre') *** returned 6 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 ***

+++++++++++++++++++++++++++++++++

SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, 'vagus') *** returned 213 rows ***

SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, 'pneumogastric') *** returned 514 rows
***

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

I am getting the same results on my XP (SP2) machine running the
express editions of Management Studio and Sql Server 2005.



.

Relevant Pages

  • Re: Thesaurus Problem
    ... Did you save your thesaurus file with Unicode encoding? ... Looking for a SQL Server replication book? ... SELECT FullDocNo ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Thesaurus Problem
    ... 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. ... > SELECT FullDocNo ...
    (microsoft.public.sqlserver.fulltext)
Loading