title: How to determine which databases are being used on SQL Server 2000
body: <p>I have a SQL Server 2000 box that houses several databases, some of which are probably no longer in use.  I'd like to clean things up by first taking them offline, and then later removing them all together.  The problem is that I don't know how to tell which of these are still being actively used (outside sources may or may not be connecting to them, using them, etc.)</p>
  
  <p>Is there a way to tell the time of the last activity on each database?  I know that SQL Server keeps records of some things in sys tables, but I'm not sure what exactly is stored there.  If what I need cannot be found there, is there something I can set up to track usage from this point forward?  Ideally, I'd like to be able to see usage "up to this point in time", but "from this point forward" would be better than nothing.  Thanks.</p>