Is there a way to determine the last actual update to any table in a Database in Ms SQL 2005
Posted on 2012-03-18
We are doing a comparison on 5 databases, doing restore from various years. We came upon a problem as to what year is the database we are working in. This is because we are working in various areas within SQL and has been over a week doing in all of these areas. So we get confused as to what DB we are working in.
What we have done today is just rename the DB with by placing the year in from of it. For example, the DB production DB is names DBcompany1, we restore X year as XXXX_DBcompany1 (ex. 2009_DBcompany1, 2009_DBcompany2, etc.)
We are looking for a script that we can run and know what is the last date the database has been updated any tables.