Full Text Status

What does the status "Notifications Processing" mean in
FullTextCatalogs? I have been unable to find any doumentation on this
status.
I means you are using change tracking with update index in background and
indexing is in progress.
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
<dan.tichy@.gmail.com> wrote in message
news:1126881520.327373.166360@.o13g2000cwo.googlegr oups.com...
> What does the status "Notifications Processing" mean in
> FullTextCatalogs? I have been unable to find any doumentation on this
> status.
>

Full Text shutdown status

I have a large full text index (30 millions records) that is
populating on a live server (they are just doing without the full text
search stuff for now) and the index goes into shutdown mode. What is
that? Last time it did this i stopped and started the mssearch
service and it started back up again. The only problem is that when
it completed last time the number of records in the index was like 8
million. I did a test and a bunch of the rows did not get into the
population even though it supposedly finished correctly. So I am
hesitant to restart the service since I'm afriad it will not
completely fill the index again.
This is SQL 2000 on a Windows 2003 entprise box. But not in a
cluster. It's a stand alone machine. 4 proc, 16 gigs on the machine.
13 of the gigs used by sql. The box does stay pretty busy but not
completely bogged down.
Ryan
are there any event messages in the application log from MSSearch or MSSCI?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"RyanOly" <ryanoly@.gmail.com> wrote in message
news:661760f9.0407141123.66388c39@.posting.google.c om...
> I have a large full text index (30 millions records) that is
> populating on a live server (they are just doing without the full text
> search stuff for now) and the index goes into shutdown mode. What is
> that? Last time it did this i stopped and started the mssearch
> service and it started back up again. The only problem is that when
> it completed last time the number of records in the index was like 8
> million. I did a test and a bunch of the rows did not get into the
> population even though it supposedly finished correctly. So I am
> hesitant to restart the service since I'm afriad it will not
> completely fill the index again.
> This is SQL 2000 on a Windows 2003 entprise box. But not in a
> cluster. It's a stand alone machine. 4 proc, 16 gigs on the machine.
> 13 of the gigs used by sql. The box does stay pretty busy but not
> completely bogged down.
> Ryan

FTS index updating

Hello,
Is it possible to know status of FTS index on value in some column of
row, I mean, how can I know FTS index have been updated already or haven't
? For example, value of some row has been changed, but FTS index hasn't
been changed yet. I need to know when after value updating I can run FTS
queries. Does any body know some way to do this, and is it possible or not?
Thank you
There are many ways of doing this - however, they are all complex.
If you are using change tracking you could poll sysfulltextnotify, and key
off the ftkey column which corresponds to your primary key.
You could also enable logging and poll the log looking for the pk value. To
do this go to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G ather\SQLServer\SQL0000500
005 (using the SQL 0000X0000X which corresponds to your catalog), and set
LogDisabled to 1.
Then there is the code sample which accompanies this article which can be
used to trap for a specific row.
http://msdn.microsoft.com/library/de...tml/sp04f9.asp
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
<denis_rusakov@.epam.com> wrote in message
news:epbCZ%23mnFHA.3036@.TK2MSFTNGP14.phx.gbl...
> Hello,
> Is it possible to know status of FTS index on value in some column of
> row, I mean, how can I know FTS index have been updated already or haven't
> ? For example, value of some row has been changed, but FTS index hasn't
> been changed yet. I need to know when after value updating I can run FTS
> queries. Does any body know some way to do this, and is it possible or
not?
> Thank you
>
>
|||Thank you very much
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23pyvuPonFHA.572@.TK2MSFTNGP15.phx.gbl...
> There are many ways of doing this - however, they are all complex.
> If you are using change tracking you could poll sysfulltextnotify, and key
> off the ftkey column which corresponds to your primary key.
> You could also enable logging and poll the log looking for the pk value.
> To
> do this go to
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G ather\SQLServer\SQL0000500
> 005 (using the SQL 0000X0000X which corresponds to your catalog), and set
> LogDisabled to 1.
> Then there is the code sample which accompanies this article which can be
> used to trap for a specific row.
> http://msdn.microsoft.com/library/de...tml/sp04f9.asp
> --
> 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
> <denis_rusakov@.epam.com> wrote in message
> news:epbCZ%23mnFHA.3036@.TK2MSFTNGP14.phx.gbl...
> not?
>