469,610 Members | 1,962 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

SQL 2005 - Full Text Index question

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

Aug 22 '07 #1
0 1293

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

22 posts views Thread by edgrsprj | last post: by
reply views Thread by Marcel - IDUG Europe 2005 | last post: by
reply views Thread by Marcel - IDUG Europe 2005 | last post: by
6 posts views Thread by sathyashrayan | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.