Can't get AND to work.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mufasa - 01 Apr 2007 15:41 GMT

I have a contains string that says ' "Log In" ' which works fine and returns
results. I put in ' "Log" or "In" ' and I get results. I put in ' "Log" and
"In" ' and get "Informational: The full-text search condition contained
noise word(s)."

Any thoughts?

What I want to do is be able to have multiple terms with ands in the
expression.

TIA - Jeff.

Reply to this Message

Hilary Cotter - 01 Apr 2007 18:32 GMT

Remove the words in from your noise word list. As you appear to be in the
States, empty the noise.enu or noiseenu.txt files and replace them with a
single space. Then rebuild your catalogs. You should be able to search on
them now.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>I have a contains string that says ' "Log In" ' which works fine and
>returns results. I put in ' "Log" or "In" ' and I get results. I put in '
[quoted text clipped - 7 lines]
>
> TIA - Jeff.

Reply to this Message

Mufasa - 02 Apr 2007 21:26 GMT

Thanks for the help.

> Remove the words in from your noise word list. As you appear to be in the
> States, empty the noise.enu or noiseenu.txt files and replace them with a
[quoted text clipped - 12 lines]
>>
>> TIA - Jeff.

Reply to this Message

Hilary Cotter - 03 Apr 2007 15:36 GMT

You're welcome.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Thanks for the help.
>
[quoted text clipped - 14 lines]
>>>
>>> TIA - Jeff.

Reply to this Message

Mufasa - 12 Apr 2007 21:22 GMT

Hilary,
That didn't seem to work. I changed both the noise.enu and for grins the
noise.eng file to be a single space. I also regenerated the full text index.

Now if I try where contains ( webpagetext, '"IN"' ) I still get
the Informational: The full-text search condition contained noise word(s).
message.

Any thoughts?

TIA - Jeff.

> You're welcome.
>
[quoted text clipped - 16 lines]
>>>>
>>>> TIA - Jeff.

Reply to this Message

denistc - 14 Apr 2007 03:12 GMT

Did you restart the msftesql service after updating the noise list?
Best regards,
-Denis.

> Hilary,
> That didn't seem to work. I changed both the noise.enu and for grins the
[quoted text clipped - 28 lines]
> >>>>
> >>>> TIA - Jeff.

Reply to this Message

Mufasa - 19 Apr 2007 12:50 GMT

The machine has been completely rebooted, and the text index was rebuilt.

It sounds like the file was not saved correctly. But I've checked it. I've
also done a search for noise.enu and there is only one copy on the machine -
in the Windows\System32 directory.

> Did you restart the msftesql service after updating the noise list?
> Best regards,
[quoted text clipped - 38 lines]
>> >>>>
>> >>>> TIA - Jeff.

Reply to this Message

Daniel Crichton - 20 Apr 2007 09:25 GMT

Mufasa wrote on Thu, 19 Apr 2007 07:50:33 -0400:

> The machine has been completely rebooted, and the text index was rebuilt.
>
> It sounds like the file was not saved correctly. But I've checked it. I've
> also done a search for noise.enu and there is only one copy on the machine
> - in the Windows\System32 directory.

That doesn't sound right. Here are the location of the noise files on my own
SQL Server installations.

v7 - c:\MSSQL7\FTDATA\SQLServer\Config

2000 - c:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config

2005 - c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData

The noise.enu file is for the US English language setting. If you are using
International English, you have to edit the noise.eng file. For other
languages, you need to edit the appropriate noise.<ISO country code> file.

Dan

Reply to this Message