Re: Last login
From: william.huang (william.huang_at_saturn.yzu.edu.tw)
Date: 06/29/05
- Next message: Sue Hoegemeier: "Re: Permissions not enforced"
- Previous message: pigeon: "Re: Re: Port 1433 is open to internet, how can I secure db?"
- In reply to: Hari Prasad: "Re: Last login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 29 Jun 2005 11:26:40 +0800
thanks
the second one did help
"Hari Prasad" <hari_prasad_k@hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:OxxfTt7eFHA.3160@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> SQL Server by default will not store the Last login time in any system
> tables.
>
> But you could go for any of the below 2 approaches to attain this:-
>
> 1. Enable the audit level for successful login and Faile Logins using
> Enterprise manager ... SECURITY tab. This will put all the
> successful and failed logins to sql server in sql server error log. You
> could open the log and identify the last login time.
>
> 2. Write a stored procedure and read the Master..sysprocesses table every
> 1 minute (use SQL Agent jobs) and put it into a user defined table.
> Later you could read this table to identify the last login time..
>
> Thanks
> HARI
> SQL Server MVP
>
>
>
>
> "william.huang" <william.huang@saturn.yzu.edu.tw> wrote in message
> news:OkGa0g6eFHA.3836@tk2msftngp13.phx.gbl...
>> Hello everybody!!
>> Do you know how to find out the last login time for all acccounts ?
>> please, to instruct for me.
>> thank you very much. :lol:
>>
>>
>
>
- Next message: Sue Hoegemeier: "Re: Permissions not enforced"
- Previous message: pigeon: "Re: Re: Port 1433 is open to internet, how can I secure db?"
- In reply to: Hari Prasad: "Re: Last login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
