Fulltext search "IT manager"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

soonyu - 23 Nov 2007 10:25 GMT

i remove "IT" from noise word and rebuild fulltext
and when i query it won't give error message anymore "Informational: The
full-text search condition contained noise word(s)."

but it return no result
any clue?

SELECT top 10 j.position
from myjob j (NOLOCK)
INNER JOIN CONTAINSTABLE(job,position,'"IT Manager"') ft ON ft.[key] =
j.job_id

Reply to this Message

Hilary Cotter - 26 Nov 2007 14:45 GMT

You need to rebuild the catalogs after removing IT from the noise word
lists.

Signature

http://www.zetainteractive.com - Shift Happens!

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>i remove "IT" from noise word and rebuild fulltext
> and when i query it won't give error message anymore "Informational: The
[quoted text clipped - 7 lines]
> INNER JOIN CONTAINSTABLE(job,position,'"IT Manager"') ft ON ft.[key] =
> j.job_id

Reply to this Message