Wednesday, March 7, 2012

Noise words

Could someone tell me how I "turn off" the noise word filtering for SQL server?

My problem is that I use the neutral language (defaults to english) and it strips out some words I do not want stripped from my queries. So in this particular case, I would like to be able to turn off noise word filtering altogether.

Ideas?

Noise words are stored in a text file, by default, it is in

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\

Just edit the noiseNEU.txt for neutral language. Delete the word in the file. You may need to restart sql server and recrawl your index.

No comments:

Post a Comment