MS SQL Server -

Hello,

I am reverse engineering database requirements for systems at work.
One of the way of identifying old or obselete data is to find out when
was the last time the data was updated/inserted into the field. Would
it be possible to run a query to get last time the data was altered or
modified?

Thanks,

HiteshHi

You would have to maintain your own datetime to record this.

John

"Hitesh" <zerocoo_@.hotmail.com> wrote in message
news:30ca6fbb.0406141238.564f6037@.posting.google.c om...
> Hello,
> I am reverse engineering database requirements for systems at work.
> One of the way of identifying old or obselete data is to find out when
> was the last time the data was updated/inserted into the field. Would
> it be possible to run a query to get last time the data was altered or
> modified?
> Thanks,
> Hitesh