How to run SQL Profiler trace to see last time database was accessed?

Joemonkey

Diamond Member
Mar 3, 2001
8,859
4
0
I'm trying to figure out when the last time a few databases we have were accessed. I think we stopped using a few, and they have been backed up, but I would like to delete any databases we are no longer using. Google search brought up running an SQL Profiler Trace, but I got lost when I opened up the profiler and don't know what exactly to look for.
 

bunker

Lifer
Apr 23, 2001
10,572
0
71
I'm not sure how to find the last accessed time, but a profiler trace won't tell you unless it is running when someone accesses it. The profiler captures real-time data about what's going on in the database.