Wednesday, March 7, 2012

Noise words issue in full text seach Sql server 2000

Hi All,

I have been using full text search in my application for search purpose.
But on certain words i.e Noise Words such as And,After,About etc.
I am receiving the following error:

Execution of a full-text operation failed. A clause of the query contained only ignored words.

I tried a lot to sort out this issue,but this is going to be out of my scope.
If anybody can help me then it would be really appreciable.

Thanks in Advance,
Vivek RathoreFull-text maintains a list of noise words in different files which are language specific. When you receive the Msg 7619 The query contained only ignored words" SQL server has eliminated all words in the query. If you would like to search on those words you can try utilizing FREETEXT or editing the files maintaining the list of noise words.

These noise-word lists should be sufficient for most normal operations, but can be modified for specific environments with a text editor. For more information, see the Indexing Service 2.0 documentation in the Windows NT 4.0 Option Pack.

No comments:

Post a Comment