Find databases with no recent activity Is there some SQL that I can use in order to find out which databases on the Server haven't been used recently?  I need to find the ones that are no longer used and detach them.
No, unless you


logged access in your tables
had a trace (SQL Profiler) running
have a logon trigger
...


You have to explicitly monitor this somehow.

If you need to do it now, you could make the database single user and see who calls...