Login Question | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Login Question

Hello, Is there a way to identify when a login last accessed the server or the database. I have several logins that I would like to clean up and I wanted to find out when that login last accessed the sever or the database. Thanks in advance for any input Rinu
The best you can do is to profile Login Audit in SQL Profiler over a period of time. Then you can see which logins havent been used recently. Theres no way of determining this otherwise that I know of
… and additionally you can check Security event log for information on that login access time.
Also enable the Audit Level to Success or All on the SQL Server to write to the log, be aware it will increase the SQL Server error log file size. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.