Hi,
Does anyone know of a neat way to monitor if a particular database has been accessed and why whom ?
At the moment I take a snapshot of the Activity Monitor at 7 min. intervals, through these dynamic views: sys.dm_exec_sessions and sys.sysprocesses. But I find this to be too inaccurate.
I would like to monitor logins aswell, but then I´m not talking about server logins, I mean more when someone issues for example use <database>.
The reason I want this is we want to upgrade one 2005 instance to 2008, and I´m thinking about moving databaes one at a time, therefor also doing a cleanup of databases that are not needed.