Monday, March 12, 2012

How long register the Databases without access?

Hi Friends...
I want to know if exist a possibility to check who was the last user in
acceding some databases, and how time passed after it.
I need to know this, because i have more than 100 databases on a clustered
server and i supposed that more than 20 are unused.
Thanks all!Hi
Not possible unless you switch on extensive auditing like C2 in SQL Server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:15369103-F255-402F-A148-FEA183AEA2D3@.microsoft.com...
> Hi Friends...
>
> I want to know if exist a possibility to check who was the last user in
> acceding some databases, and how time passed after it.
> I need to know this, because i have more than 100 databases on a clustered
> server and i supposed that more than 20 are unused.
> Thanks all!
>

No comments:

Post a Comment