A clause of the query contained only ignored words

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
http://www.indexserverfaq.com/noise.htm
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
"Abe Simpson" <abe@.simpson.com> wrote in message
news:%23QMJJHpGFHA.3916@.TK2MSFTNGP12.phx.gbl...
> 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
>
|||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
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Abe Simpson" <abe@.simpson.com> wrote in message
news:#QMJJHpGFHA.3916@.TK2MSFTNGP12.phx.gbl...
> 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
>
sql