title: Check last database usage?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/201990/how-can-i-determine-the-last-time-any-record-changed-in-a-specific-sql-server-20">How can I determine the last time any record changed in a specific Sql Server 2000 database?</a>  </p>
  </blockquote>
  
  
  
  <p>I've been asked by my employer to migrate all of the currently used databases from one server to another and then "archive" all of the databases no longer being used.</p>
  
  <p>The problem I'm having is that there's little to no documentation as to which applications are making use of which databases on the server and there's not much convention to the name scheme either.  Unfortunately, we "support" a lot of third party software here and things are messy, to say the least.</p>
  
  <p>The approach which I'd like to use would be to migrate any databases that have seen transactions within the last month or so and then just offline and backup the others.</p>
  
  <p>The problem I have is that I'm not sure how to check for activity on a given database?  Is there something I can use that tells me if anything has been going on?</p>