• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1074
  • Last Modified:

Full-Text Searches: Can I disable the noise words filter?

I'm still quite new to Full-Text searches and am currently writing a simple search engine for a forum.
I am using the CONTAINSTABLE method and each of my search terms are seperated with 'AND' rather than 'OR'.

If I type in any noise words amongst my search terms, I get an error returned. Is there any way around this? I.e. Can I tell SQL to not worry about Noise words, just let it search on them also if they are entered?

Thanks in advance.
0
Starnzy
Asked:
Starnzy
  • 5
  • 3
1 Solution
 
danblakeCommented:
What is the error that is returned ?
0
 
Anthony PerkinsCommented:
>>Is there any way around this? <<
Sure you can delete them from the noise file.  It is just a text file.  However, I suspect there is a better solution.  Try posting your query here.
0
 
StarnzyAuthor Commented:
I heard from somewhere that if you delete them from the noise file, at some point they are 'regenerated' by SQL into this text file again?!!
Whether this is complete myth or not I don't know. I will try your suggestion though and see what happens, thanks.
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
Anthony PerkinsCommented:
>>at some point they are 'regenerated' by SQL into this text file again?!!<<
Right.  That would be the next time you re-install SQL Server :)
0
 
StarnzyAuthor Commented:
This is the error I am getting, even after emptying the contents of 'noise.eng' in the 'CONFIG' folder...

System.Data.SqlClient.SqlException: Execution of a full-text operation failed. A clause of the query contained only ignored words.

In this example I was doing a search which contained the word 'doing'.

Any ideas?
0
 
Anthony PerkinsCommented:
>>This is the error I am getting, even after emptying the contents of 'noise.eng' in the 'CONFIG' folder...<<
You need to do a full-population of your full-text catalog after making any change to your noise file. Also, make sure you are modifying the right one :)
0
 
Anthony PerkinsCommented:
Any luck?
0
 
StarnzyAuthor Commented:
Hi.

I appear to still get 2 different types of error, even after doing a full-population of my full-text catalog.

If I use the word 'AND' as one of my search terms I get the following error:

System.Data.SqlClient.SqlException: Syntax error occurred near ' and AND test2')'. Expected '_NOT, '(', _ISABOUT, _FORMSOF, _STRING, _PREFIX_STRING, '!'' in search condition 'test1 AND and AND test2'.

Also, if I typed in for example the search terms 'doing a year' I got the following error still:

System.Data.SqlClient.SqlException: Execution of a full-text operation failed. A clause of the query contained only ignored words.

Any ideas?

Thanks
0
 
Anthony PerkinsCommented:
Assuming you modified the correct noise file, then I have no idea.
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now