Re: Ignored Words Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Kane (jt-kane_at_comcast.net)
Date: 05/18/04 

Date: Tue, 18 May 2004 07:23:12 -0700

Farhan,
A bit more info on this "by design" error. This is a common issue for SQL
Server 2000 Full-text Search (FTS) in that words that are contained in the
noise word files (noise.*, where * represents a 3 letter language extension)
located in the folder \FTDATA\SQLServer\Config where you have SQL Server
2000 installed. The file Schema.Txt has the 3 letter language extension that
related to specific language, for example noise.enu is US_English, noise.eng
is UK_English and noise.dat is for when you use the Neutral "Language for
Word Breaker". You can edit these files with notepad.exe and remove the word
"between", however you will need to stop the "Microsoft Search" (mssearch)
service before saving the file. Once you've made your change, you should run
a Full Population on all of your FT Catalog on the server.

Regards,
John

"news.microsoft.com" <oleg@opel.com.ua> wrote in message
news:esMAPfKPEHA.308@TK2MSFTNGP11.phx.gbl...
>
> Look on file noise.dat or noise.<your language>
> And edit it if you need.
>
> Regards,
> Oleg Cherkasenko
>
>
> "Farhan Iqbal" <mr_farhaniqbal@hotmail.com> wrote in message
> news:%23lXjpbKPEHA.2636@TK2MSFTNGP10.phx.gbl...
> > Hi,
> > i have problem with full-text search.
> > I make full-text catalog and i run this query:
> >
> > SELECT * FROM tmp WHERE CONTAINS(Full_Text_Search, 'between')
> >
> > and i receive error
> > 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.
> >
> > help Please
> >
> >
>
>

Relevant Pages

  • Re: Inserting new records into a large ADO table
    ... Regards, ... Vassiliev V. V. ... >> executes one SQL statement for each change in the CDS.Delta property. ... >> If you insert 1,000 rows the DSP will create and send to the server ...
    (borland.public.delphi.database.ado)
  • Re: changing data type or converting
    ... This is normally more a client side display thing, than a server side task. ... SQL does have the round() function: ... Regards ...
    (microsoft.public.sqlserver.programming)
  • RE: Cannot install certificate...help?
    ... resource kit named setcert.exe to specify the certificate used by SQL ... Server for SSL encryption. ... Best Regards, ...
    (microsoft.public.sqlserver.security)
  • Re: Text search on separate machine
    ... KB article 240867 procedures require that SQL ... Server and the MSSearch service be installed on all/both machines. ... >> Regards, ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)