Re: Ignored words error strangeness

Thanks for the help Hilary and John

The noise files (noise.eng and noise.enu) don't appear to have been edited
and look to contain all the default noise words.

I did unintentionally have the one table/FT index giving the error set on US
English, so I dropped the FT index, and recreated it (with the same name if
that matters) with UK English selected, and then did a full population,
however I'm still getting the error currently.

any other ideas? I'll keep playing with it.

Thanks
Matt


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:%23NDo$EcJGHA.1028@xxxxxxxxxxxxxxxxxxxxxxx
> What noise word lists are you looking at? For SQL 2000 you should be
> looking at the ones in C:\Program Files\Microsoft SQL
> Server\MSSQL$instanceName\FTDATA\SQLServer$instanceName\Config
>
> or
>
> C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config
>
> For SQL 2005 you should be looking at C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\FTData
>
> Note that the International English (English_UK - LCID 2057) and the
> American English (English_US - LCID 1033) use the same word breakers in
> SQL 2000 - they implement different stemmers. In SQL 2005 they use
> different word breakers and stemmers.
>
> The problem you are encountering is with the stemmers.
>
> One of the reasons you might be getting this error is if you have deleted
> the contents of your noise word list. You should enter an single space if
> you want to delete the contents.
> --
> 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
>
> "Matt Jensen" <replytonewsgroups@xxxxxxxxxxxxx> wrote in message
> news:uO1PQ4YJGHA.528@xxxxxxxxxxxxxxxxxxxxxxx
>> Howdy
>>
>> I've got 2 databases on the same SQL server with full text indexes on the
>> columns of tables, and one when I do a full text search on with a noise
>> word eg 'a' it returns results with a in it, and the other one gives the
>> 'ignored words' error.
>>
>> When I do sp_help_fulltext_columns on the two tables, one gives 2057, one
>> gives 1033, however the noise.eng and noise.enu appear to be identical on
>> the server.
>>
>> Anyone got any ideas what the difference may be, I just want to turn this
>> feature off really?
>>
>> Cheers
>> Matt
>>
>>
>
>


.

Relevant Pages
Loading