I have a sql server with 80 databases.
management studio 2012 -> activity monitor -> Processes ->
under the drop down for database I only have about 10 db's listed. I am assuming that these are the ones that are active at the current time.
is there a way to run a log that will log all logins to all databases on the sql instance over a period of lets say a week?
I need this to figure out which db's are still in use and which ones are not.
if there is a better way to accomplish this - please advise.