Can't get AND to work.

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.
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.
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
"Mufasa" <jb@.nowhere.com> wrote in message
news:%23BdhgvGdHHA.4872@.TK2MSFTNGP03.phx.gbl...
>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.
>
|||Thanks for the help.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O$DM0OIdHHA.208@.TK2MSFTNGP05.phx.gbl...
> 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.
> --
> 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
>
> "Mufasa" <jb@.nowhere.com> wrote in message
> news:%23BdhgvGdHHA.4872@.TK2MSFTNGP03.phx.gbl...
>
|||You're welcome.
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
"Mufasa" <jb@.nowhere.com> wrote in message
news:%23RiY9UWdHHA.4784@.TK2MSFTNGP06.phx.gbl...
> Thanks for the help.
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:O$DM0OIdHHA.208@.TK2MSFTNGP05.phx.gbl...
>
|||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.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23w5O$1fdHHA.2268@.TK2MSFTNGP02.phx.gbl...
> You're welcome.
> --
> 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
>
> "Mufasa" <jb@.nowhere.com> wrote in message
> news:%23RiY9UWdHHA.4784@.TK2MSFTNGP06.phx.gbl...
>
|||Did you restart the msftesql service after updating the noise list?
Best regards,
-Denis.
"Mufasa" wrote:

> 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.
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23w5O$1fdHHA.2268@.TK2MSFTNGP02.phx.gbl...
>
>
|||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.
"denistc" <denistc@.discussions.microsoft.com> wrote in message
news:38149F6E-B714-446F-B6E0-31057D7D7B71@.microsoft.com...[vbcol=seagreen]
> Did you restart the msftesql service after updating the noise list?
> Best regards,
> -Denis.
> "Mufasa" wrote: