469,950 Members | 2,353 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

Thesaurus Search - How to update the XML?

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

Aug 8 '07 #1
0 1224

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Hans Malherbe | last post: by
2 posts views Thread by hammad | last post: by
3 posts views Thread by Marc | last post: by
3 posts views Thread by moondaddy | last post: by
8 posts views Thread by johnerics | last post: by
4 posts views Thread by kachokaratz | last post: by
reply views Thread by Calvin Spealman | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.