Full text thesuarus

Hot Topic

How to format leave detail into tabular/pivot format?
Distributed Transaction completed error
Using variables in SSIS
dynamic query
Problem making backup of an SQL Server database
Certificate limitations in SQL Server 2005
KB913580 related problem
Frustrating Installation Error
Copy VS Create
Metadata storage and intelligent use

SQL Server

How to Get Error Output from and OLE DB Command Destination
SQLDumper
SQL 2005 Developer edition fails during installation
SSIS performance
problem regarding relationship
Cannot connect to "Reporting Services" using Microsoft Sql Server Management Studio.
Is it possible to dynamically populate a parameter list with values based on another parameter value?
How would you archive a subset of your db if you had to?
Error using pivot transform
Complex Transformations (SSIS components vs TSQL)

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
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>
            <sub>SIVAN</sub>
            <sub>SHIVA</sub>
            <sub>SIVA</sub>
        </expansion>
 <replacement>
            <pat>SVAN</pat>
            <pat>siiv</pat>
            <sub>SIVAN</sub>
        </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

Answer this question

Full text thesuarus

  • rayfusion

    Ok I pulled the big switch! And Viola it Works. Thanks for the info.
    Is this nugget of info documented somewhere

  • FreddyParra

    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

  • dic_brookes

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

    K TTongue Tied

  • UMI20

    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>
                <sub>SIVAN</sub>
                <sub>SHIVA</sub>
                <sub>SIVA</sub>
            </expansion>
     <replacement>
                <pat>SVAN</pat>
                <pat>siiv</pat>
                <sub>SIVAN</sub>
            </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




  • Full text thesuarus
Answer this question