Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2007

    Unanswered: Full Text search is not returning any row


    I have installed SQL Server 2000 with SP4 on a Windows 2000 Server with Full Text Search component.

    I have created one Full Text catalog on three text columns of a table. But, when I am issuing a SELECT SQL with CONTAINS in SQL Query Analyzer, it is not returning any row.

    I am not getting any clue why Full text search is not working since it is not returning any error.
    Following is the SELECT command what I am issuing:
    SELECT * FROM postingdetails
    WHERE CONTAINS(pd_t_postingtitle,'web')

    The column, 'pd_t_postingtitle' contains the word 'web' in 4 records.
    Therefore it should return 4 rows. Instead, it is returing 0 rows.

    I hope some body must have faced a similar problem and can help me out.

    Last edited by sdatta65; 12-17-07 at 05:23.

Posting Permissions

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