Implicit (system) timestamp per record?

[codestorm]

Does it exist?

I've got a table of dates things happened to a user, and some of the fields are missing (noone bothered to mod the code to populate them).

I'm hoping that MSSQL has some hidden field(s) which store the datetime a record was created/last modified.

If so I could update the missing fields based on the record creation/last modified datetimes of other records in other tables.

Keyword seaches here and at MSDN show nothing so far.

codestorm
Newbie Life Member.
Fire bad. Tree pretty. - Buffy
<insert witticism here>

 

[donutman]

AFAIK, only if you explicitly created the timestamp field or if the table is part of a replication plan.
-Karl