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