Full-Text indexes are not dynamically maintained like SQL Server's native indexes are. You must periodically refresh them. Manually refreshing them and try your query again.
You'll probably find that you need to create a job to periodically refresh the indexes. The SEM can help you with this.
-Mike
>Hi,
>
>Here is the query I am using for my full-text searching:
>
>SELECT COUNT(*) as hits
>FROM links a, links_details b INNER JOIN
>CONTAINSTABLE (links_details, *, @strSearch, 200 ) c
>ON b.link_id = c.[KEY]
>WHERE (a.link_id=b.link_id) AND (c.rank>70)
>OPTION (KEEPFIXED PLAN)
>
>
>If @strSearch = "small business" the query returns all the results in the table that match.
>
>However, if @strSearch = "small business opportunities" the query returns no results even though there are records in the full-text indexed column that contain this exact phrase, in that exact order.
>
>Is there anything I can or need to do to the query to make it work properly?
>
>TIA,
>Mike