Post reply

Full index Text search is not include the Noise words

  • January 12, 2009 at 4:58 am

    #198134

    Hi all,

    I have tried to configure the Full Index Text search in Sql Server 2005.Its working well, but it is not including the ignorance of Noise words when search. It consider Noise words in search. how to enable it should not be check the noise words?

    Thanks,

    Siva

  • January 12, 2009 at 5:20 am

    #925191

    Sorry, but I can't tell if you are stating that it is using the noise words in the search or it is ignoring them in the search. Either way though the noise words are contained in a text file (check BOL for location information). You can edit that file but note that it will change the noise word filtering for all FT indexes on that instance. Once you edit that file you have to rebuild the FT Index in order for it to become effectual.

    Hope that helps.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • January 12, 2009 at 5:25 am

    #925193

    I don't think there is a function or option to enable/disable usage of noise words in SQL. The problem could the noise words file, which contains the noise words and it is located in "$SQL_Server_Install_Path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\" as "Noise[LanguageCode].txt"

    Edit:

    And as david said, you have to rebuild the FT indexes in order to see the changes.

    --Ramesh

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply