title: How to get last insert/update/delete datetime on Sql Server 2005?
body: <p>not a duplicate of <a href="https://stackoverflow.com/questions/1227593/how-to-get-last-modification-datetime-on-sql-server-2005">my previous question</a></p>
  
  <p>Is there any way to get the latest datetime when a table/database had an insert/update/delete on Sql Server 2005? Preferably without creating triggers..</p>
  
  <p>I know that when you need the last update per row, you need triggers. But I am not sure if they are needed when you just want to get the last update for the whole table.</p>