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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>