Hi!

I'm using the Thesaurus search on a SQL Server 2005 Db

The thesaurus file is built like this (Reduced version)

<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics = false/>
<expansion>
_William
_Billy
</expansion>
<expansion>
_Maria
_Mary
</expansion>
<expansion>
_Paul
_Pablo
</expansion>
<expansion>
_Richard
_Ricky
</expansion>
<expansion>
_Rebecca
_Reba
_Becky
</expansion>
</thesaurus>
</XML>

And so on.

It is working perfectly, but how can I make SQL Server aware of the
fact that I changed (Adding expansions) the file without rebooting the
whole server?

As of now I can add all the changes, but the server doesn't recognize
tha new extensions until I reboot the machine. Why?

P