Results 1 to 2 of 2

Thread: Full text issue

  1. #1
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    1

    Post Unanswered: Full text issue

    Hello,

    I run a music related website (www.LowestCostMusic.com) and I'm using the SQL2000 full text search engine.

    If you go to the site via this link... It would be searching on the phrase 'the way it is'

    http://www.lowestcostmusic.com/searc...=the+way+it+is

    Which is all noise words... yet could be a title of some sheet music that we carry. I need to know how to build the SQL full text catalog to allow this search to work properly... Any ideas? Thanks!

    -Matt

  2. #2
    Join Date
    Feb 2002
    Location
    Seattle, WA
    Posts
    3

    Lightbulb

    Matt,

    Thanks for using Microsoft SQL Server 2000 and Full-Text Search on your web site. This should help:

    You need to update your noise words list and then repopulate your Full-Text index in order to accept searches on titles such as "the way it is" . You may find your noise word files under:

    \Program Files\Microsoft SQL Server\MSSQL$INSTANCENAME\Ftdata\SQLServer\Config\ noise.enu (for US English)

    You may add words to be excluded from the index, and likewise remove words that you would like included.

    Once you are satisfied with changes, restart MSSearch service and you will need to repopulate your catalogs.

    This should fix your problem right away.

    All the best,
    --andrew

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •