SQL Server Full-Text Search - ignored words...how to configure

Author

ignored words...how to configure

Gordowey

2005-10-27, 7:55 am

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

John Kane

2005-10-27, 7:56 am

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\Co
nfig where you
have SQL Server installed. If your using CONTAINS, do you get the same error
with FREETEXT?

Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

"Gordowey" < albertoiriarte@gmail
.com> wrote in message
news:1130189170.846032.204350@g44g2000cwa.googlegroups.com...
>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
>

Gordowey

2005-10-27, 7:56 am

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_FU
LL_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

Hilary Cotter

2005-10-27, 7:56 am

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.

--
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
"Gordowey" < albertoiriarte@gmail
.com> wrote in message
news:1130244963.060388.244040@o13g2000cwo.googlegroups.com...
> 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_FU
LL_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
>

Gordowey

2005-10-27, 7:56 am

Thanks very much!

Sponsored Links