ignored words...how to configure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gordowey - 24 Oct 2005 22:26 GMT

I am looking for "ABOUT" and i get this error

Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. A clause of the query
contained only ignored words.

how can i get around this error?

How can I exclude "about" from the reserved word, sinde is the name of
a magazine that I want to be able to search in my data base..

thanks

Reply to this Message

John Kane - 25 Oct 2005 06:06 GMT

Gordowey,
Could you provide the full output of -- SELECT @@version -- from the server
where you're getting this error? This info is helpful in troubleshooting SQL
FTS issues. Are you using CONTAINS or FREETEXT. If the former, have you
removed "have" from the language-specific noise word file? Noise.enu = US
English and these files are located under \FTDATA\SQLServer\Config where you
have SQL Server installed. If your using CONTAINS, do you get the same error
with FREETEXT?

Thanks,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

>I am looking for "ABOUT" and i get this error
>
[quoted text clipped - 8 lines]
>
> thanks

Reply to this Message

Gordowey - 25 Oct 2005 13:56 GMT

I am using this

SELECT @@version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 (Build 3790: )

and this query

select
[KEY] objDoc,
RANK RANK
from
CONTAINSTABLE(TAB_FULL_TEXT_NET, *, 'about', 300)

I tried to remove from the noise words file, but i got an error. Should
i stop my sql server for that (the file seem to be locked)

thnaks

Reply to this Message

Hilary Cotter - 25 Oct 2005 14:58 GMT

issue a net stop mssearch from the command line. Make your save, and then
restart mssearch. After you have completed this you should rebuild your
catalogs to be able to search on rows which contain the word about.

Signature

Hilary Cotter
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 am using this
>
[quoted text clipped - 15 lines]
>
> thnaks

Reply to this Message

Gordowey - 25 Oct 2005 16:22 GMT

Thanks very much!

Reply to this Message