Sunday, February 19, 2012

How to browse the history login detail of sqlserver?

Hi all,
I want to ask how to browse the history login detail of
sqlserver.eg:login user name , client ip and login time
thx.Hi
SQL server does not store it, unless you log it specifically though code
into a table.
If you have full auditing on, you can see the date and time of a specific
login (success or failure).
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/
"zlf" <zlfcn@.hotmail.com> wrote in message
news:Oj$X$xOLFHA.1916@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I want to ask how to browse the history login detail of
> sqlserver.eg:login user name , client ip and login time
> thx.
>|||Thank you for your help
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ะด?:uGD9k3OLFHA.1176@.TK2MSFTNGP12.phx
.gbl...
> Hi
> SQL server does not store it, unless you log it specifically though code
> into a table.
> If you have full auditing on, you can see the date and time of a specific
> login (success or failure).
> 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/
> "zlf" <zlfcn@.hotmail.com> wrote in message
> news:Oj$X$xOLFHA.1916@.TK2MSFTNGP12.phx.gbl...
>

No comments:

Post a Comment