How to determine the last time when records have been inserted, updated or deleted for a table?
<blockquote>
  <p><strong>Possible Duplicate:</strong><br>
  <a href="http://stackoverflow.com/questions/9505032/how-to-make-a-search-function-for-sql-database-and-how-to-get-time-when-info-f">How to make a search function for sql database , and how to get time when info from a table was edited?</a>  </p>
</blockquote>



<p>How can I determine the last time when records have been inserted,
updated or deleted for a table ?</p>

<p>someone told me </p>

<pre><code>select *
from sys.dm_db_index_usage_stats
where database_id = db_id( 'readpasttest' )
</code></pre>

<p>But I don't know how to use it  I have a database table on asp.net site where I add informations like this:</p>

<pre><code>edit-1.Name : Jax
edit-2.Age : 24
edit-3.Code : 12515
</code></pre>

<p>so when the users edit something lets say the name Jax it will be like this</p>

<pre><code>edit-1.Name : newName - This was edited last time : the time/day !
</code></pre>

<p>Please help ,ty</p>
