Re: Last login
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/28/05
- Next message: Hoof Hearted: "Permissions not enforced"
- Previous message: william.huang: "Last login"
- In reply to: william.huang: "Last login"
- Next in thread: william.huang: "Re: Last login"
- Reply: william.huang: "Re: Last login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 28 Jun 2005 13:59:55 +0530
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: Hoof Hearted: "Permissions not enforced"
- Previous message: william.huang: "Last login"
- In reply to: william.huang: "Last login"
- Next in thread: william.huang: "Re: Last login"
- Reply: william.huang: "Re: Last login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
