"I D" <idror@healthology.com> wrote in message
news:uz#BxOrVDHA.2272@TK2MSFTNGP11.phx.gbl...
> Why when searching for more than one word in a text search and at least

> for example : if the search text is "what does Allergist do?" i get the
msg despite the fact "Allergist" is not noise word.
> this is how i query it:
> select a.* from containstable(tbl_sSearchMain, keywords,
'FORMSOF(INFLECTIONAL,What) and
> FORMSOF(INFLECTIONAL,Does) and
> FORMSOF(INFLECTIONAL,the) and
> FORMSOF(INFLECTIONAL,Allergist) and
> FORMSOF(INFLECTIONAL,Do)') as a
> join tbl_sSearchMain
> on a.[key] = tid
> order by a.rank desc
>
> thx!
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &

>-----Original Message-----
>I D,
>Unfortunately, this is expected behavior when
using "noise words", such as
>"the" and "do" and assuming that US_English is your FT-
enabled column's
>"Language for Word Breaker" (defined in the FT Indexing
Wizard, when you
>created the FT Catalog) as these words are in the noise
word file (noise.enu
>for US_English) under \FTDATA\SQLServer\Config. You could
remove these words
>and then re-run a Full Population, but then you would
still have to deal
>with other noise words and your FT Catalog would get
bigger with these
>common 'noise' words, as they add no significant input
for FTS queries.
>
>You can also try using a "phrase" search, i.e. use double
quotes around a
>multiple word string that contains these noise words and
then the noise
>words are truly ignored, for example:
>
>select a.* from containstable(tbl_sSearchMain,
keywords,'"what does
>Allergist do?"') and FORMSOF(INFLECTIONAL,Allergist)
>
>For more info, see SQL Server 2000 BOL title "Full-Text
Search
>Recommendations" as well as the following KB article
246800 (Q246800) "INF:
>Correctly Parsing Quotation Marks in FTS Queries"
>http://support.microsoft.com//default.aspx?scid=kb;EN-
US;246800. Also,
>search this newsgroup for past postings of Hilary
Cotter's client-side
>solution using SearchPage.htm for cleaning up the noise
words prior to
>submitting the FTS query to SQL Server.
>
>Regards,
>john
>
>
>
>"I D" <idror@healthology.com> wrote in message
>news:uz#BxOrVDHA.2272@TK2MSFTNGP11.phx.gbl...
>> Why when searching for more than one word in a text
search and at least
>one word (but not all) is a noise word i get the msg -
"The query contained
>only ignored words" .
>> for example : if the search text is "what does
Allergist do?" i get the
>msg despite the fact "Allergist" is not noise word.
>> this is how i query it:
>> select a.* from containstable(tbl_sSearchMain, keywords,
>'FORMSOF(INFLECTIONAL,What) and
>> FORMSOF(INFLECTIONAL,Does) and
>> FORMSOF(INFLECTIONAL,the) and
>> FORMSOF(INFLECTIONAL,Allergist) and
>> FORMSOF(INFLECTIONAL,Do)') as a
>> join tbl_sSearchMain
>> on a.[key] = tid
>> order by a.rank desc
>>
>> thx!
>>
>>

>> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
>> Comprehensive, categorised, searchable collection of
links to ASP &
>ASP.NET resources...
>
>
>.