Hello all,
We are using sql server 2005 for full text searching.
I removed some of the words in the noise word file (noiseENU.txt) and rebuilt the catalog. However i find that the changes made to the noise file do not reflect immediately. I had to restart sql server engine before my queries returned results according to the updated noise list. Is there a workaround for this ( wherein there isnt the neccesity of restarting sql server engine....this is becoming a problem on live environments as i cannot restart the server when needed)?
Thanks in advance,
Harish
In fact you will only have to start the FTS again to reflect the changes. There is no (even no one to me) known way around this.
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||Thank You.
But i had tried restarting just the FTS service; didn't work out for me until i restarted the sql server engine again
No comments:
Post a Comment