jason davis

I understand that in order to use incremental population I need a TimeStamp
field.
However, I want to allow re-population of a record only when CERTAIN columns
are changed.

For example:

I have a table called Products , with Product_watched_counter and
Product_title/Product_desc.

I want to re-populate the record (change timestamp?) only when Product_title
or Product_desc is changed, but not when Product_watched_counter is changed.

My FTS does not include Product_watched_counter in the indexed columns, will
it work?

Thanks!

john kane

Jason,
What version of SQL Server do you have installed?
If you're using SQL Server 7.0, then Incremental Population is your only
option, however, if you're using SQL Server 2000, you can enable "Change
Tracking" with "Update Index in Background" and get what you are trying to
achieve. CT and UIiB are new features with SQL Server 2000 only.

Regards,
John