Is there a way of determining when a given user last logged into SQL Server? We are about to carry out an audit of our database server and would like to delete users that are redundant.
Incidentally I'm interested in users at the server-level (i.e. Logins), not users of individual databases.
Thanks in advance.
Even if you have Login auditing for successful logins enabled, it depends how far back your SQL errorlogs go.
I asked this question before...
sql-server-find-last-time-user-was-connected
I think I ended up running some sql that read master..sysprocesses for new logins at regular intervals over a period using sql agent.