THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Modifying the Thesaurus in Full Text Search in SQL Server 2008

This blog has moved! You can find this content at the following new location:

Published Wednesday, August 13, 2008 7:47 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Microslave said:

Thanks a lot for the hint about the ambiguous information in BOL concerning the location of the thesaurus configuration file! I DID find the corresponding file in the default installation path (for my German locale that was "tsdeu.xml") and modified it. After some hours of trying, restarting, searching the web, modifying my queries, creating new tables and sample queries, I was finally desperately lost until I found this information. I then switched to my Data Folder (d:\SQL2008\Data\MSSQL10.MSSQLSERVER\MSSQL\FTData\) and modified the correct file this time and it worked like a charm (well after some timeout errors after trying to update thesaurus configuration with sys.sp_fulltext_load_thesaurus_file).

Sometimes you're completely on the wrong track (or in the wrong folder at least), so I learned that one must indeed sometimes question the infos in BOL, although this stays #1 SQL Server resource for me! So thanks again, for sharing your knowledge. :-)

September 2, 2010 2:09 PM

pag said:

Trying to get this thing working on AWS RDS.

Any help in that regard ?


November 21, 2016 6:06 AM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement