Problem is, doesn't that control the entire database server? I'm using my
ISP's database so I can't neccessarily change that file. Any other ways if
this is true?
Jeff
> There is a file containing the noise words, in your SQL Server directory,
> under ftdata\SQLServer\Config.
> There is a separate noise word file for each supported language. They are
> all just text files, and you can easily edit them.
> The one for English is noise.enu is for US English. You can add or remove
> words as you like.
> HTH
> --
> Kalen Delaney
> MCSE, SQL Server MCT, MVP
> www.InsideSQLServer.com
> Feed Someone for Free Today:
> www.TheHungerSite.com
> > I hope someone can help with this one. I have a full text index on a
table
> > and in my query I am performing a contains search for a particular
phrase.
> > I've encounterd a problem that if someone search for a title that has
all
> > ignored words the query fails. Is there a way around this?
> > Here is an example:
> > Some is searching for "Way of the"
> > My query is - Select headline, body from news where contains(body, "
'way
> of
> > the' ")
> > I get an error that states my query contains all ignored words. Is "way"
> an
> > ignored word? How can I avoid this?
> > Thanks,
> > Jeff
by