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 outstanding database.

As a result, some tables seem to be outdated, but it is very difficult to say which ones.

Is there any way to get, for each table, the date/time of the last insert command performed against it?

score 3 · Accepted Answer · edited Jul 29 '20 at 18:21

3

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.

edited Jul 29 '20 at 18:21

Community

1
1

answered May 08 '09 at 01:01

Kenneth Cochran

11,954
3
52
117

I'm in luck, i'm using SQL Server 2005 ! :o) Thanks for the link. – Sylvain Rodrigue May 08 '09 at 01:02

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

1 Answers1

Linked