Dino & Rich,
Rich, you are correct, in that these files noise.* where * = language, i.e.,
noise.enu = US_English and these files can be edited with notepad.exe. Note,
the MSSearch service must be stopped to save these files. However, you must
add some client-side logic to capture the error first in the user search
string, for example see KB article 246800 (Q246800) "INF: Correctly Parsing
Quotation Marks in FTS Queries"
http://support.microsoft.com//default.aspx?scid=kb;EN-US;246800 and other
postings in this newsgroup for SearchPage.htm code examples. Also, if you're
using SQL Server 2000, see BOL title "Full-Text Search Recommendations" for
more examples and help on customizing SQL FTS.
Regards,
John
[quoted text, click to view] "Rich" <richbrownesq@hotmail.com> wrote in message
news:%23DAD20kQDHA.2648@TK2MSFTNGP10.phx.gbl...
> There is a list of words that sql server ignores when building a catalog
and
> can't be queries on and are called, "noise" words or ignored words.
Examples
> of these include "the", "and", "a", "1" etc...
>
> You can find a list in a file called noise.* (enu in my case depends on
the
> language i think) and can be found in MSSQL\FTDATA\Config\
>
> I believe this file can be edited to suit requirements but i would suggest
> that removing words could result in signifcantly larger indexes and poor
> performance. Though that is just my guess and haven't tried it.
>
> Hope this helps!
> R
>
> "Dino M. Buljubasic" <dino.buljubasic@rivusglobal.com> wrote in message
> news:P4hNa.50202$T85.5737080@news1.telusplanet.net...
> > > I am having a problem when querying data from database.
> > > Some of the queries throw an exception and I don't know how to fix it.
> > >
> > > The error I get is "Query Contains Only Ignored Words" (#7619)
> > >
> > > Any help would be appreciated
> >
> >
> > --
> > Dino Buljubasic
> > Software Developer
> >
http://rivusglobal.com > >
> >
>
>
