Results 1 to 4 of 4

Thread: FullText Search

  1. #1
    Join Date
    Nov 2002

    Unhappy Unanswered: FullText Search

    I have create a table called tblcatalog with colums id(identity,primary key) and contents(varchar(100))

    I have then created a full text catalog on that table and populated it.

    Then i wrote the following query
    "select contents from tblcatalog where contains(contents,'sample data')"
    It is fetching 0 records even though u have 5 records with entries "sample data"

    Can anyone tell me the solution immediately


  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Immediately? Have you tried everything you could think of before asking for help? It'll take me 20 minutes or so to setup FullText Search, and will take you probably much less to experiment with it.

  3. #3
    Join Date
    Feb 2004
    San Antonio, TX
    when you say you populated it did you create an initial full population?

  4. #4
    Join Date
    Apr 2004
    Forgive me if this is basic to you. Just trying to be thorough.
    In Enterprise Manager, right click on your table. Choose 'Full Text Index Table' (MS Search service must be started for this to appear.) Choose 'Start full population.' Rerun your query. If it works, you must not have really done a full population yet. In that case you may want to set up incremental or full populations using the 'Schedules..' option on the same context menu...
    If not, I have no clue what the problem is!

Posting Permissions

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