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>
<sub>William</sub>
<sub>Billy</sub>
</expansion>
<expansion>
<sub>Maria</sub>
<sub>Mary</sub>
</expansion>
<expansion>
<sub>Paul</sub>
<sub>Pablo</sub>
</expansion>
<expansion>
<sub>Richard</sub>
<sub>Ricky</sub>
</expansion>
<expansion>
<sub>Rebecca</sub>
<sub>Reba</sub>
<sub>Becky</sub>
</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
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>
<sub>William</sub>
<sub>Billy</sub>
</expansion>
<expansion>
<sub>Maria</sub>
<sub>Mary</sub>
</expansion>
<expansion>
<sub>Paul</sub>
<sub>Pablo</sub>
</expansion>
<expansion>
<sub>Richard</sub>
<sub>Ricky</sub>
</expansion>
<expansion>
<sub>Rebecca</sub>
<sub>Reba</sub>
<sub>Becky</sub>
</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