Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Auditing to fetch the details of lastlogin date of user in SQL server Expand / Collapse
Posted Wednesday, December 11, 2013 10:03 AM


Group: General Forum Members
Last Login: Monday, March 17, 2014 3:56 AM
Points: 14, Visits: 64
How to use auditing to get the lastlogin date of the user in SQL??
or is there any other way to fetch the result?
Post #1521971
Posted Thursday, December 12, 2013 4:29 AM



Group: General Forum Members
Last Login: Today @ 3:45 AM
Points: 17,172, Visits: 32,133
You can set up extended events to capture logins. That's the one sure way to get it. But if you haven't set that up, I'm not sure there is a way.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1522230
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse