 Thesaurus Search - How to update the XML? -
08-08-2007
, 12:29 PM
Hi!
I have the DB, now with about 100 Million rows (Going strong!!!)
One question... I'm using Thesaurus search (COOL!!!) for names,
(Rebecca, Reba, Becky, Becca....) to query for nicknames ans Synonyms,
but I don't seem to be able to update the XML file in real time.
The file is like this:
<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<expansion>
<sub>William</sub>
<sub>Will</sub>
<sub>Bill</sub>
<sub>Billy</sub>
</expansion>
<expansion>
<sub>Rebecca</sub>
<sub>Reba</sub>
And so on...
But, when I make some changes to it, the only way (As far as I know)
to make SQL Server use them is to restart the whole thing.
Is there any other way?
Thanks!
Piero Giorgi
|
Linear Mode
