Msg 7619 error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harolds - 28 Apr 2006 23:29 GMT

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

When I do the following:
select * FROM SomeTable
where CONTAINS(FullTextSearchEnabledField, 'P.A.s')

Can someone tell me why I get this error?

Signature

Harolds

Reply to this Message

Hilary Cotter - 29 Apr 2006 11:15 GMT

locate your noise word lists and replace them with a single file. For SQL
2000 you can find them in

C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config

or

C:\Program Files\Microsoft SQL
Server\MSSQL$InstanceName\FTDATA\SQLServer$InstanceName\Config and they look
like noise.eng (UK english) or noise.enu (US English).

For SQL 2005 you can find them in

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData and they look
like
noiseenu.txt and noiseeng.txt.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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 get the following error:
> Msg 7619, Level 16, State 1, Line 1
[quoted text clipped - 6 lines]
>
> Can someone tell me why I get this error?

Reply to this Message