FTS

Last Post 01 Sep 2011 06:26 PM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dbandee
New Member
New Member

--
31 Aug 2011 10:01 AM
good afternoon
I have quick question please.
Should i have TIMESTAMP column on tables on which i will be created Full_Text index?
Microsoft says "you should have TIMESTAMP column for any table where are using full text index" 
It does not sound like a "must have"

My question is do i have to have Timestamp column if am planning to add Full text indices to the database (is is new db being designed, so it is not an changing table structure at all)

thank you
rm
New Member
New Member

--
31 Aug 2011 11:31 AM
Don't think so, we use FTI on tables without timestamp column (not even any datetime column).
gunneyk
New Member
New Member

--
01 Sep 2011 06:26 PM
A TimeStamp column is required if you want to do incremental po***tion of the catalogs. If all you do is full po***tion then it is not needed. But if you want to do incremental that is the way it tracks which rows have changed since the last time.


Acceptable Use Policy
---