Full text thesuarus

Did you restart the Full-text service after changing the thesaurus? Go to My Computer->Manage->Services and Application->SQL Server Configuration Manager->SQL Server 2005 Services to find and restart it. Best regards Michael <kts@.discussions.microsoft.com> wrote in message news:fbfb65e9-e043-4f50-8995-479b19b0d690@.discussions.microsoft.com...I am not able to get the thesaurus to work during search. Do I need to edit the thesaurus before building the index or is it used during query time.here is my tsENU.xml<XML ID="Microsoft Search Thesaurus"><thesaurus xmlns="x-schema:tsSchema.xml"> <diacritics_sensitive>0</diacritics_sensitive> <expansion> _SIVAN _SHIVA _SIVA </expansion> <replacement> <pat>SVAN</pat> <pat>siiv</pat> _SIVAN </replacement></thesaurus></XML>This query returns no results select * from ucn_master where freetext(fname,'svan')even though there are occurance of 'SIVAN'.Any help for this newbe query is much appreciated.K TI am not able to get the thesaurus to work during search. Do I need to edit the thesaurus before building the index or is it used during query time.
here is my tsENU.xml

<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
_SIVAN
_SHIVA
_SIVA
</expansion>
<replacement>
<pat>SVAN</pat>
<pat>siiv</pat>
_SIVAN
</replacement>
</thesaurus>
</XML>

This query returns no results

select * from ucn_master where

freetext(fname,'svan')

even though there are occurance of 'SIVAN'.

Any help for this newbe query is much appreciated.

K T|||Nope!. No luck I restarted the full text service twice !

K T|||Ok I pulled the big switch! And Viola it Works. Thanks for the info.
Is this nugget of info documented somewhere ?|||The first refresh of Books Online that should be available for download by the time SQL Server 2005 will be available will contain more information about how to manage thesauri. I will make sure that this info is included as soon as possible.

Best regards
Michael

Full Text Search - Thesaurus

Dear All,

I am not able to activate thesaurus in SQL Server 2005. With some help I was able to use noise files but thesaurus is uphill. The following is my tsENU.xml file:

<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
_ANTHONY
_TONY
</expansion>
</thesaurus>
</XML>

All I want is, ANTHONY and TONY to be treated as synonymous.

The following is my query:

SELECT CONTACTID, FULLNAME
FROM CONTACT
WHERE CONTAINS (FULLNAME, ' FORMSOF (THESAURUS, TONY) ')

and

SELECT CONTACTID, FULLNAME
FROM CONTACT
WHERE FREETEXT (FULLNAME, 'TONY')

To no awail. Am I missing some thing here? Kindly help me to go thru this.
I even restarted the sqlftservice and recreated the index but to no use.

thanks and regards

SQLDBA123

Here is an example thesaurus file:

<XML ID="Microsoft Search Thesaurus">

<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics = false/>
<replacement>
<pat>W2K</pat>
_{Windows 2000}
_NT
</replacement>

<replacement>
<pat>Internet Explorer</pat>
_IE
_{IE 5}
</replacement>

<replacement>
<pat>Internet</pat>
_intranet
</replacement>

<expansion>
_run
_jog
</expansion>

<replacement>
<pat>seek</pat>
_went
</replacement>

</thesaurus>

</XML>

Please replace the corresponding thesaurus with this example and restart msftesql service. Now thesaurus should work. The problem is that the example in the thesaurus file is wrong on diacritics setting property.

thanks,

Jingwei

Full Text Search - Thesaurus

Dear All,

I am not able to activate thesaurus in SQL Server 2005. With some help I was able to use noise files but thesaurus is uphill. The following is my tsENU.xml file:

<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
_ANTHONY
_TONY
</expansion>
</thesaurus>
</XML>

All I want is, ANTHONY and TONY to be treated as synonymous.

The following is my query:

SELECT CONTACTID, FULLNAME
FROM CONTACT
WHERE CONTAINS (FULLNAME, ' FORMSOF (THESAURUS, TONY) ')

and

SELECT CONTACTID, FULLNAME
FROM CONTACT
WHERE FREETEXT (FULLNAME, 'TONY')

To no awail. Am I missing some thing here? Kindly help me to go thru this.
I even restarted the sqlftservice and recreated the index but to no use.

thanks and regards

SQLDBA123

Here is an example thesaurus file:

<XML ID="Microsoft Search Thesaurus">

<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics = false/>
<replacement>
<pat>W2K</pat>
_{Windows 2000}
_NT
</replacement>

<replacement>
<pat>Internet Explorer</pat>
_IE
_{IE 5}
</replacement>

<replacement>
<pat>Internet</pat>
_intranet
</replacement>

<expansion>
_run
_jog
</expansion>

<replacement>
<pat>seek</pat>
_went
</replacement>

</thesaurus>

</XML>

Please replace the corresponding thesaurus with this example and restart msftesql service. Now thesaurus should work. The problem is that the example in the thesaurus file is wrong on diacritics setting property.

thanks,

Jingwei

FTS Thesaurus Diacritics

Has anyone played with the <diacritics> or <diacritics_sensitive> tag in the
thesaurus for FTS? If so, have you actually gotten it to affect your
results? It doesn't matter what I change it to, in testing it appears to be
over-ruled by the FT Catalog accent sensitivity setting.
"Mike C#" <xyz@.xyz.com> wrote in message
news:OWqzQennHHA.3512@.TK2MSFTNGP06.phx.gbl...
> Has anyone played with the <diacritics> or <diacritics_sensitive> tag in
> the thesaurus for FTS? If so, have you actually gotten it to affect your
> results? It doesn't matter what I change it to, in testing it appears to
> be over-ruled by the FT Catalog accent sensitivity setting.
After a little further review, it appears the <diacritics> and
<diacritics_sensitive> tags are not even included in the schema definition
for the thesaurus files. There is an optional "weight" attribute assigned
to the <sub> elements, however. Is this documented anywhere?
Thanks.