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 (dotNetD***@discussions.microsoft.com) writes:
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. :-)

bcp accent problem
can not find the relationship in 2005
What is SQL2005 final build number?
SQL Server 2005
Select and ID Column
Database Diagrams
Documented Bug in SQL Server 2005?
Business Intel. Dev. Studio loads VS.Net 2005
Difference between RPC:Completed and SP:Completed
Network Monitor