Full Text Search Failed for the word 'is'

I am implementing a full text search. When I search for the word 'is', it is
giving a wrong result. I need the help to solve this problem.
either do a freeText search, which will in most cases prevent this error, or
remove is from your noise word list.
Hilary
"narayananst" <narayananst@.discussions.microsoft.com> wrote in message
news:EF9989EB-A396-4F22-BCBA-696133B24D51@.microsoft.com...
>I am implementing a full text search. When I search for the word 'is', it
>is
> giving a wrong result. I need the help to solve this problem.
|||Narayananst,
The word "is" is typically a "noise word" or sometimes referred to as a stop
word that is contained in a language-specific noise word file, as it is so
common in the English language that it provide no significant help in Full
Text Search. However, you can edit or removed from the language specific
noise.* file (noise = US_English) with notepad.exe.
These files are located under \FTDATA\SQLServer\Config\noise.* where *
represents the language - enu = US_English. You will need to stop the
MSSearch service, edit noise.enu (assuming US_English) with notepad.exe and
remove these letters and save the file, restart the MSSearch service and run
a Full Population on all of your FT Catalogs. I'd recommend that you remove
"is" and other noise words that you may want to search on, but not empty the
entire file or at least leave a single space in the file.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"narayananst" <narayananst@.discussions.microsoft.com> wrote in message
news:EF9989EB-A396-4F22-BCBA-696133B24D51@.microsoft.com...
> I am implementing a full text search. When I search for the word 'is', it
is
> giving a wrong result. I need the help to solve this problem.