sql server full text search: Change tracking does near real time updates. To enable change tracking use the following pro

sp_fulltext_table 'TableName','start_change_tracking
sp_fulltext_table 'TableName','start_background_updateindex

You do not need a timestamp column on your table

If you want to do an incremental index and your table has a time stamp column you have to manually kick off the indexing process. If your table does not have a timestamp column a full population will be run, and again you have to manually kick it off

use

sp_fulltext_table 'TableName','start_incremental' -- for an incremental populatio

or

sp_fulltext_table 'TableName','start_full' -- for a full populatio

Looking for a SQL Server replication book
http://www.nwsu.com/0974973602.htm


----- TR wrote: ----

I have just begun to experiment with the full text searching capabilities i
SQL2000. Very happy so far! Nice work. I like the INFLECTIONAL results

When the user makes a change or addition to a row's full-text-indexed colum
(e.g. adds the phrase "now available in brushed aluminum" to the Descriptio
column) what needs to be done so that the full-text indexes reflect th
change/addition and the row will be found in subsequent searches? Is ther
a daemon that does reindexing periodically that needs to be configured, o
can updates be made to appear in real time, or does the index have to b
rebuilt in toto manually

Thanks
T

I have just begun to experiment with the full text searching capabilities in
SQL2000. Very happy so far! Nice work. I like the INFLECTIONAL results.

When the user makes a change or addition to a row's full-text-indexed column
(e.g. adds the phrase "now available in brushed aluminum" to the Description
column) what needs to be done so that the full-text indexes reflect the
change/addition and the row will be found in subsequent searches? Is there
a daemon that does reindexing periodically that needs to be configured, or
can updates be made to appear in real time, or does the index have to be
rebuilt in toto manually?

Thanks!
TR

Thanks!