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

Tip: Looking for answers? Try searching our database.

Full Text Search Failed for the word 'is'

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
narayananst - 24 Jan 2005 13:19 GMT
I am implementing a full text search. When I search for the word 'is', it is
giving a wrong result. I need the help to solve this problem.
Hilary Cotter - 24 Jan 2005 13:59 GMT
either do a freeText search, which will in most cases prevent this error, or
remove is from your noise word list.

Hilary
>I am implementing a full text search. When I search for the word 'is', it
>is
> giving a wrong result. I need the help to solve this problem.
John Kane - 25 Jan 2005 05:23 GMT
Narayananst,
The word "is" is typically a "noise word" or sometimes referred to as a stop
word that is contained in a language-specific noise word file, as it is so
common in the English language that it provide no significant help in Full
Text Search. However, you can edit or removed from the language specific
noise.* file (noise = US_English) with notepad.exe.

These files are located under \FTDATA\SQLServer\Config\noise.* where *
represents the language - enu = US_English. You will need to stop the
MSSearch service, edit noise.enu (assuming US_English) with notepad.exe and
remove these letters and save the file, restart the MSSearch service and run
a Full Population on all of your FT Catalogs. I'd recommend that you remove
"is" and other noise words that you may want to search on, but not empty the
entire file or at least leave a single space in the file.

Regards,
John

Signature

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

> I am implementing a full text search. When I search for the word 'is', it is
> giving a wrong result. I need the help to solve this problem.
 
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.