Results 1 to 4 of 4

Thread: FullText Search

  1. #1
    Join Date
    Nov 2002
    Posts
    2

    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

    bye
    shanky

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    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
    Location
    San Antonio, TX
    Posts
    565
    when you say you populated it did you create an initial full population?

  4. #4
    Join Date
    Apr 2004
    Posts
    5
    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
  •