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 / July 2004

Tip: Looking for answers? Try searching our database.

Neutral Noise file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Guy Brom - 29 Jul 2004 12:44 GMT
Hi there,

To ignore noise words errors (i.- 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. )

I've searched and emptied the content (not deleted) from all occurences of
the noise.dat file.

I restarted mssearch before and after deleting, but still - I get this error
when trying to search for "dream AND 2".

Anything I'm missing here?

Thanks!

Guy
Hilary Cotter - 29 Jul 2004 13:39 GMT
issue a sp_help_fulltext_columns in the database which you are full text
indexing.

this will tell you which columns you are indexing, and the word breakers you
are using in the FULLTEXT_LANGUAGE

to correlate this with your noise word list issue a master.dbo.xp_MSfulltext
and note the language which LCID's value matches the value for your columns
returned in the sp_help_fulltext_columns query.

noise.dat is for the neutral word breaker with a LCID of 0.
noise.enu is for US English with an LCID of 1033
noise.eng is for British English with an LCID of 2057

Does this match the noise word list you are using?

Did you modify the list in C:\Program Files\Microsoft SQL
Server\MSSQL\FTDATA\SQLServer\config?

Lastly did you wrap your search phrase in double quotes?

ie

select * from tablename where contains(*,'"dream and 2"')

thats a single quote, a double quote, dream and 2, double quote, single
quote.

Signature

Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html

> Hi there,
>
[quoted text clipped - 14 lines]
>
> Guy
Guy Brom - 29 Jul 2004 20:41 GMT
Hilary hi,

All FULLTEXT_LANGUAGE rows are 0. I modified all occurences of noise.dat,
and yes, I'm wrapping everything in double quotes, i.e-

select * from tablename where contains(*,'"dream and 2"')

Is that wrong?

Thanks.

> issue a sp_help_fulltext_columns in the database which you are full text
> indexing.
[quoted text clipped - 44 lines]
> >
> > Guy
Hilary Cotter - 30 Jul 2004 01:29 GMT
what is in your noise.dat file? if it is 0 bytes, open it up and put a
single blank space in it and then save it.

> Hilary hi,
>
[quoted text clipped - 60 lines]
> > >
> > > Guy
Guy Brom - 30 Jul 2004 09:41 GMT
It was indeed 0 bytes. I've added the single blank space and it worked.
Thank you! Thank you!

> what is in your noise.dat file? if it is 0 bytes, open it up and put a
> single blank space in it and then save it.
[quoted text clipped - 64 lines]
> > > >
> > > > Guy

Rate this thread:






 
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



©2008 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.