Won't ignore noise words, even after editing noise.enu -- HELP!

I'm trying to get SQL Server to ignore the noise words for the
Full-Text indexed content in a given column. I've edited the noise.eng
and noise.enu files in the c:\winnt\system32 directory so they only
have one word: qxqxqxq. So any other words will not be ignore and will
get get indexed, right?

But it's not working. After dropping the existing FT index, editing the
noise file, re-starting the SQL Server Full-Text and SQL Server
services, and then creating a new FT index, it still ignores what it
thinks are noise words. For example, I search for "as far as":
CONTAINS (colName, '"as far as"'))
but it finds all rows with "far", whether or not they have "as far as"
-- it just ignores "as", since it still considers this a noise word.

I've also tried changing the default FT Index langauge to something
besides English, like Chinese -- thinking that "as" probably isn't a
Chinese noise word (Server / Properties / Advanced / Default Full-Text
Language; changing 1033 to 1028). But same problem, even after starting
and re-starting services, etc etc.

I've spent four hours on this now, and no luck. Any suggestions? Thanks
in advance.

Mark D.

.

Relevant Pages

  • Re: a clause of the query contained only ignored words
    ... Purely for diagnostic purposes could you run this script on your SQL Server ... to find these noise words in your searches you will have to rebuild>> your catalog. ... > same error but now it works correctly, so I'm pretty sure I edited the> correct noiselist and rebuilt the catalog correctly. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Ignored words problem
    ... I agree that the "A clause of the query contained only ignored ... been a pain ever since SQL 7.0 Beta3 was shipped in 1998 and once SQL Server ... sp_configure 'transform noise words' - so you can turn off this check in SQL ... database and searching on 'book' will not return rows that contain 'books': ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FT Search with nois words
    ... Looking for a SQL Server replication book? ... > What I want is that the words will be ignored but the query will still ... Looking for a string like ... > A option is ofcourse to remove the noise words from the string in my ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Storing large documents in SQL Server
    ... but this depends on the number of words you can consider to be noise words ... marginal improvement in indexing and querying time. ... Looking for a SQL Server replication book? ... > We are debating whether it is a good idea to store large documents in SQL server itself OR to strip the document of the "noise" words outside of sql server and store just the words we need to be indexed. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FT Search with nois words
    ... UserID = (SELECT UserID FROM ForumPost WHERE TopicID = Total.TopicID ... Looking for a string like ... A option is ofcourse to remove the noise words from the string in my ... > SQL Server has a config file that specifies all the noise words it ignores ...
    (microsoft.public.sqlserver.fulltext)