navimir
SSC Eights!
Points: 872
More actions
December 11, 2013 at 10:03 am
#395972
How to use auditing to get the lastlogin date of the user in SQL??
or is there any other way to fetch the result?
Grant Fritchey
SSC Guru
Points: 398916
December 12, 2013 at 4:29 am
#1672886
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
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply