473,287 Members | 1,418 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

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 1364

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

22
by: edgrsprj | last post by:
PROPOSED EARTHQUAKE FORECASTING COMPUTER PROGRAM DEVELOPMENT EFFORT Posted July 11, 2005 My main earthquake forecasting Web page is: http://www.freewebz.com/eq-forecasting/Data.html ...
0
by: Marcel - IDUG Europe 2005 | last post by:
Dear DB2 user, My name is Marcel Lévy and I'm a member of the IDUG 2005 Europe Conference Planning Committee. ********************************************************************* Mark your...
0
by: Marcel - IDUG Europe 2005 | last post by:
Dear DB2 user, My name is Marcel Lévy and I'm a member of the IDUG 2005 Europe Conference Planning Committee. ********************************************************************* Mark your...
6
by: sathyashrayan | last post by:
Following are the selected thread from the date:30-jan-2005 to 31-jan-2005. I did not use any name because of the subject is important. You can get the original thread by typing the subject...
5
by: R.A.M. | last post by:
Hello, I am learning SQL Server 2005 Expres Edition. I need to create full text index on Books.Remarks column in my database. I tried: CREATE FULLTEXT CATALOG FTC_Books AS DEFAULT CREATE...
1
by: RAM | last post by:
Hello, I have installed SQL Server 2005 Express Edition Advanced Services and SQL Server 2005 Express Edition Toolkit SP1. I cannot use full-text search. When I called: exec sp_fulltext_service...
8
by: Sham | last post by:
I am trying to perform the following query on a table that has been indexed using Full Text Search. The table contains multiple columns than have been indexed. (Below, all xml columns are...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.