Last Access to the Database

Is there a tool for SQL Server 2000 that will tell me the last time all the
databases were accessed on the server? I'm trying to detemin which databases
are not used anymore or not very often.
Thanks,
David
======================================
David McCarter
www.vsdntips.com
VSDN Tips & Tricks .NET Coding Standards available at:
www.cafepress.com/vsdntips.20412485
dotNetDave (dotNetDave@.discussions.microsoft.com) writes:
> Is there a tool for SQL Server 2000 that will tell me the last time all
> the databases were accessed on the server? I'm trying to detemin which
> databases are not used anymore or not very often.
No, there is no such feature.
If you are an evil man, you use set the databases offline, and see how
many people scream.
If you are more the conflict-avert sort of person, you can set the
suspected databases to autoclose. If memory serves, you can then trace
an access by looking at the dates for the MDF files. But there is a
catch here: if anyone browse the list in EM and is not sysadmin, EM
will have to open the DB to see if that person has access. Or it could
be due to any other random visit.
Slightly more reliable is to run a trace, but you may need to run it
for three montns or so.
Personally, I think being evil is a good qualification for a DBA. :-)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx