Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / February 2005

Tip: Looking for answers? Try searching our database.

A clause of the query contained only ignored words

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Abe Simpson - 24 Feb 2005 16:55 GMT
Hi all,

I am getting this error when my query contains a word like "of":

"A clause of the query contained only ignored words."

The SQL statement uses the CONTAINS clause. This used to work fine on SQL
Server 2000, but I recently switched to SQL Server 2003 and can't get it to
work. I don't want to have any ignored words. I tried to rename all noise.*
files into _noise.* and then rebuilt the Full-Text Catalog, but that did not
fix it.

Anything else I need to do to get rid of all noise words?

Thanks.

Abe
Hilary Cotter - 24 Feb 2005 19:57 GMT
http://www.indexserverfaq.com/noise.htm

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

> Hi all,
>
[quoted text clipped - 13 lines]
>
> Abe
John Kane - 25 Feb 2005 02:16 GMT
Able,
Could you post the full output of the following SQL code as it would be most
helpful information in helping you.

use <your_database_name_here>
go
SELECT @@language
SELECT @@version
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
go

You are getting this error because "of" is considered a noise or stop word
that is maintained in the language-specific noise word files under
\FTDATA\SQLServer\Config\noise.* where * is a three-letter code for your
FT-enable column's "Language for Word Breaker". Specifically, noise.enu = US
English and you can edit this file with notepad.exe and remove "of" and
other words and single letters and digits, but leave at least a single
space, if you decide to remove all noise words. Note, you will have to stop
the "Microsoft Search" (MSSearch.exe) service before saving the file and
then run a Full Population on all of your FT Catalog for the change to be
effective.

Note, there is no such version as "SQL Server 2003". Are you perhaps
refereing to SQL Server 2005 (codename Yukon)?
If so, the noise word files are maintained in a different location
(\MSSQL.1\MSSQL\Binn\FTERef) and with different file names, such as
noiseENU.txt for US English. You will also need to stop a different service
MSFTESQL and then run a Full Population. If you are not using SQL Server
2005, could you post the full output of SELECT @@version ?

Thanks,
John
Signature

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

> Hi all,
>
[quoted text clipped - 13 lines]
>
> Abe
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.