full text indexing feature of SQL Server .

I am using the full text indexing feature of SQL Server .

I have indexed two text fields in the Content table and two other text fields in the ContentDetail table

The select queries are shown below for the two seperate calls.

I want to be able to show the results based on the rank ( The column that has the best match for the searched key ).

Since I am getting two different RANK arrays from the two calls, can i resort them in the code to get the new rank order to show the results in the screen

SELECT KEY_TBL.RANK,FT_TBL.Description, FT_TBL.Title
FROM Content AS FT_TBL
INNER JOIN
CONTAINSTABLE( Content, * ,
'ISABOUT (Cancer weight(1),Survivor weight(1), Shared weight(1), Story weight(1))' ) AS KEY_TBL
ON FT_TBL.ContentID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC

SELECT KEY_TBL.RANK,FT_TBL.Description, FT_TBL.SubTitle
FROM ContentDetail AS FT_TBL
INNER JOIN
CONTAINSTABLE( ContentDetail, * ,
'ISABOUT (Cancer weight(1),Survivor weight(1), Shared weight(1), Story weight(1))' ) AS KEY_TBL
ON FT_TBL.ContentDetailID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESCThat would make a good pole...

How many dba's use this feature...

Never have...from what I understand it's a pig...|||I tried to get Full Text Search to work for a little while, until I realized you can not get "historical" to show up for searches with a search predicate of "history". I also had to make the queries in dynamic SQL, since you have so many dang quotes in the query. Pain in the neck, really.

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