I need to identify which sql server db's are active in my instance of sql server.
the sql server is running sql 2008 r2 standard.
when I try to setup an audit through management studio, it err's out and tells me auditing is not a feature allowed
on this type of sql application "2008 r2 standard"
does anyone know away I can accurately track logins to sql server databases by the database name? I have inherited a sql server that has 80 db's and I don't know which ones are being actively used.
My plan was to track logins over a week and see which db's are being utilized.