Fulltext search "IT manager"

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
You need to rebuild the catalogs after removing IT from the noise word
lists.
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
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:84274EF1-758C-458F-AD83-793104B0FBD6@.microsoft.com...
>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
>