Full Text Search Failed for the word 'is'

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.
either do a freeText search, which will in most cases prevent this error, or
remove is from your noise word list.
Hilary
"narayananst" <narayananst@.discussions.microsoft.com> wrote in message
news:EF9989EB-A396-4F22-BCBA-696133B24D51@.microsoft.com...
>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.
|||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
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"narayananst" <narayananst@.discussions.microsoft.com> wrote in message
news:EF9989EB-A396-4F22-BCBA-696133B24D51@.microsoft.com...
> 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.

Full text content index corrupt

Hello,
I am getting this error on my full text search...
Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed. The
content index is corrupt. , Server ULSM1, Procedure , Line 1
I am using SQL 2000 Standard...
This happens on only ONE of my tables... i have 2 tables, that are almost
identical in structure, but 1 table has 100k records, and the other has 600k
records..
It is the table that has 600k records where this corrupt action happens...
Can anyone help me with this? This is the first time i've seen this error
(and i've done a couple google searches, but nothing this specific).
Thank you.
Is this table the only table in its catalog? If so rebuild the catalog to
see if this solves the problem. Review the event log to see if there are any
disk errors, or errors from MSSearch or MSSCI.
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
"RL Tech" <tech_support@.nospamuls.com> wrote in message
news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I am getting this error on my full text search...
> Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed. The
> content index is corrupt. , Server ULSM1, Procedure , Line 1
> I am using SQL 2000 Standard...
> This happens on only ONE of my tables... i have 2 tables, that are almost
> identical in structure, but 1 table has 100k records, and the other has
> 600k
> records..
> It is the table that has 600k records where this corrupt action happens...
> Can anyone help me with this? This is the first time i've seen this error
> (and i've done a couple google searches, but nothing this specific).
> Thank you.
>
|||Hi Hilary,
I'll review the event log, but in the meantime i'll start the rebuild of the
catalog and see if that helps...
Thanks...
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23JMqh1lFGHA.1260@.TK2MSFTNGP15.phx.gbl...
> Is this table the only table in its catalog? If so rebuild the catalog to
> see if this solves the problem. Review the event log to see if there are
any[vbcol=seagreen]
> disk errors, or errors from MSSearch or MSSCI.
> --
> 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
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
The[vbcol=seagreen]
almost[vbcol=seagreen]
happens...[vbcol=seagreen]
error
>
|||Thanks hilary, that has helped...
Just an odd error i've never seen, nor could i find any topics on this
error.
Anyway, thanks again.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23JMqh1lFGHA.1260@.TK2MSFTNGP15.phx.gbl...
> Is this table the only table in its catalog? If so rebuild the catalog to
> see if this solves the problem. Review the event log to see if there are
any[vbcol=seagreen]
> disk errors, or errors from MSSearch or MSSCI.
> --
> 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
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
The[vbcol=seagreen]
almost[vbcol=seagreen]
happens...[vbcol=seagreen]
error
>

Full text content index corrupt

Hello,
I am getting this error on my full text search...
Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed. The
content index is corrupt. , Server ULSM1, Procedure , Line 1
I am using SQL 2000 Standard...
This happens on only ONE of my tables... i have 2 tables, that are almost
identical in structure, but 1 table has 100k records, and the other has 600k
records..
It is the table that has 600k records where this corrupt action happens...
Can anyone help me with this? This is the first time i've seen this error
(and i've done a couple google searches, but nothing this specific).
Thank you.Is this table the only table in its catalog? If so rebuild the catalog to
see if this solves the problem. Review the event log to see if there are any
disk errors, or errors from MSSearch or MSSCI.
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
"RL Tech" <tech_support@.nospamuls.com> wrote in message
news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I am getting this error on my full text search...
> Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed. The
> content index is corrupt. , Server ULSM1, Procedure , Line 1
> I am using SQL 2000 Standard...
> This happens on only ONE of my tables... i have 2 tables, that are almost
> identical in structure, but 1 table has 100k records, and the other has
> 600k
> records..
> It is the table that has 600k records where this corrupt action happens...
> Can anyone help me with this? This is the first time i've seen this error
> (and i've done a couple google searches, but nothing this specific).
> Thank you.
>|||Hi Hilary,
I'll review the event log, but in the meantime i'll start the rebuild of the
catalog and see if that helps...
Thanks...
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23JMqh1lFGHA.1260@.TK2MSFTNGP15.phx.gbl...
> Is this table the only table in its catalog? If so rebuild the catalog to
> see if this solves the problem. Review the event log to see if there are
any
> disk errors, or errors from MSSearch or MSSCI.
> --
> 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
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
The[vbcol=seagreen]
almost[vbcol=seagreen]
happens...[vbcol=seagreen]
error[vbcol=seagreen]
>|||Thanks hilary, that has helped...
Just an odd error i've never seen, nor could i find any topics on this
error.
Anyway, thanks again.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23JMqh1lFGHA.1260@.TK2MSFTNGP15.phx.gbl...
> Is this table the only table in its catalog? If so rebuild the catalog to
> see if this solves the problem. Review the event log to see if there are
any
> disk errors, or errors from MSSearch or MSSCI.
> --
> 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
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
The[vbcol=seagreen]
almost[vbcol=seagreen]
happens...[vbcol=seagreen]
error[vbcol=seagreen]
>

Full text content index corrupt

Hello,
I am getting this error on my full text search...
Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed. The
content index is corrupt. , Server ULSM1, Procedure , Line 1
I am using SQL 2000 Standard...
This happens on only ONE of my tables... i have 2 tables, that are almost
identical in structure, but 1 table has 100k records, and the other has 600k
records..
It is the table that has 600k records where this corrupt action happens...
Can anyone help me with this? This is the first time i've seen this error
(and i've done a couple google searches, but nothing this specific).
Thank you.Is this table the only table in its catalog? If so rebuild the catalog to
see if this solves the problem. Review the event log to see if there are any
disk errors, or errors from MSSearch or MSSCI.
--
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
"RL Tech" <tech_support@.nospamuls.com> wrote in message
news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I am getting this error on my full text search...
> Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed. The
> content index is corrupt. , Server ULSM1, Procedure , Line 1
> I am using SQL 2000 Standard...
> This happens on only ONE of my tables... i have 2 tables, that are almost
> identical in structure, but 1 table has 100k records, and the other has
> 600k
> records..
> It is the table that has 600k records where this corrupt action happens...
> Can anyone help me with this? This is the first time i've seen this error
> (and i've done a couple google searches, but nothing this specific).
> Thank you.
>|||Hi Hilary,
I'll review the event log, but in the meantime i'll start the rebuild of the
catalog and see if that helps...
Thanks...
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23JMqh1lFGHA.1260@.TK2MSFTNGP15.phx.gbl...
> Is this table the only table in its catalog? If so rebuild the catalog to
> see if this solves the problem. Review the event log to see if there are
any
> disk errors, or errors from MSSearch or MSSCI.
> --
> 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
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I am getting this error on my full text search...
> >
> > Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed.
The
> > content index is corrupt. , Server ULSM1, Procedure , Line 1
> >
> > I am using SQL 2000 Standard...
> >
> > This happens on only ONE of my tables... i have 2 tables, that are
almost
> > identical in structure, but 1 table has 100k records, and the other has
> > 600k
> > records..
> >
> > It is the table that has 600k records where this corrupt action
happens...
> >
> > Can anyone help me with this? This is the first time i've seen this
error
> > (and i've done a couple google searches, but nothing this specific).
> >
> > Thank you.
> >
> >
>|||Thanks hilary, that has helped...
Just an odd error i've never seen, nor could i find any topics on this
error.
Anyway, thanks again.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23JMqh1lFGHA.1260@.TK2MSFTNGP15.phx.gbl...
> Is this table the only table in its catalog? If so rebuild the catalog to
> see if this solves the problem. Review the event log to see if there are
any
> disk errors, or errors from MSSearch or MSSCI.
> --
> 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
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:O2Sb09hFGHA.3892@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I am getting this error on my full text search...
> >
> > Msg 7619, Lvl 16, State 1, Execution of a full-text operation failed.
The
> > content index is corrupt. , Server ULSM1, Procedure , Line 1
> >
> > I am using SQL 2000 Standard...
> >
> > This happens on only ONE of my tables... i have 2 tables, that are
almost
> > identical in structure, but 1 table has 100k records, and the other has
> > 600k
> > records..
> >
> > It is the table that has 600k records where this corrupt action
happens...
> >
> > Can anyone help me with this? This is the first time i've seen this
error
> > (and i've done a couple google searches, but nothing this specific).
> >
> > Thank you.
> >
> >
>