Options

The timestamp column

allanpallanp Member Posts: 2
edited 2007-09-14 in SQL General
Hi all

Is the (binary) timestamp column always increased over time - even across records and tables? That is, if I e.g. change customer AA and then change customer BB, will the timestamp for BB be "larger" than the one for customer AA? And is it also the case if I change a record in an other table? E.g. change Contact CC after customer BB, will the timestamp for Contact CC be "larger" than the timestamp for customer BB?

I am asking because one of my customers have created their own replication of customers from Navision to an other application using a DTS job. And the main criteria for replicating a customer is if the timstamp is larger than the largest of timestamps allready replicated - in theory modified since last replication. I just want to make sure that this actually allways will be the case.

Thanks
/Allan

Comments

Sign In or Register to comment.