In AppDev's courseware for SqlServer 2008 developers, I've modified the English thesaurus as per example. And although the following line completes, the fullsearch is unaware. What am I missing? EXEC
In AppDev's courseware for SqlServer 2008 developers, I've modified the English thesaurus as per example. And although the following line completes, the fullsearch is unaware. What am I missing?
EXEC
SELECT ScrapReason.Name FROM Production.ScrapReason WHERE CONTAINS (Name,'FORMSOF THESAURUS, wrong)');
SELECT
ScrapReason.Name FROM Production.ScrapReason WHERE CONTAINS (Name,'FORMSOF THESAURUS, wrong)');
- Rich McGlynn
-- tseng.xml
<XML ID="Microsoft Search Thesaurus"> <thesaurus xmlns="x-schema:tsSchema.xml"> <diacritics_sensitive>0</diacritics_sensitive> <expansion> <sub>incorrect</sub> <sub>wrong</sub> </expansion> <replacement> <pat>short</pat> <pat>small</pat> </replacement> <expansion> <sub>run</sub> <sub>jog</sub> </expansion> </thesaurus></XML>
Thank you for your post. I have forwarded your question on to an instructor.
Thank you,
Brian
First, the easy stuff (I have to ask! :-):
Did you create the Full Text Index as described previously in the chapter?Did the sp_fulltext_load_thesaurus_file procedure execute without error?Did you remember to save the changes to the tseng.xml file to its original location?And if you used Notepad to make the changes, did it add a .txt extension?
Assuming that all of that isn't the problem, what exactly happens when you run the SELECT statement? What results do you get?
Don