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.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
You can gather some info from the index usage stats DMV (unless your databases are full of tables sans indexes). Aaron Bertrand has an article here which might be of interest to you: http://goo.gl/twAlh
No, unless you
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...