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 / September 2005

Tip: Looking for answers? Try searching our database.

Removed 'c' from noise.enu

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kyle Jedrusiak - 27 Sep 2005 12:37 GMT
So I've edited all copies of noise.enu (the correct file foe US English) by
removing 'c' from the line with the alphabet.

I did restart on the Indexing service and forced a full population on the
two tables we have fulltext indexes on.

Of course I've missed something...since when I run a query with
...contains(Content, 'c') I get back the ...contains only noise words error.

Someone please set me straight.

Kyle!
Daniel Crichton - 27 Sep 2005 12:45 GMT
Kyle wrote  on Tue, 27 Sep 2005 07:37:08 -0400:

> So I've edited all copies of noise.enu (the correct file foe US English)
> by removing 'c' from the line with the alphabet.
[quoted text clipped - 7 lines]
>
> Someone please set me straight.

Are you sure your FTS is using the US English wordbreaker?

To be sure on mine I edited both noise.eng and noise.enu.

Dan
Kyle Jedrusiak - 27 Sep 2005 12:58 GMT
No, it's just me not looking at the whole system.

SQL Server is running off of drive D: and not drive C:.

So I was still editing the wrong files.  I tried to edit to correct files
and couldn't as they are in use.

So...never mind...again!

Kyle!

> Kyle wrote  on Tue, 27 Sep 2005 07:37:08 -0400:
>
[quoted text clipped - 15 lines]
>
> Dan
 
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.