SQL Server - what is the date/time of the last inserted row of a table ?

Question

My fellow programmers did not think to add timestamps to every tables of our outanding database...

Result : some tables seems to be outdated, but it is very difficult to say.

What I would really like is to get, for each table, the date/time of the last insert command performed against it.

Is it any way to tell it ?

Thanks in advance and all the best ! Sylvain.

(And sorry for my poor english.)

Answer 1

It depends on the version of SQL server you're using. SQL server 2005 or newer you try looking here. If its an older server engine you may be out of luck unless someone was proactive enough to use stored procedures and logged updates.

Answer 2

Here is an another easy way