quote:
I think ISS reads the ERRORLOG file looking for "Login succeeded for user" messages to keep track of the last time a user logged in. Anyone could just do this, but first you need to turn on auditing of successful logins.Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
I was hoping SQL stored this info in a table would have been a lot easier but looks like I am out of luck. I have modified auditing to capture both successful and failed logins (failed so I can see who may be trying to get in that shouldn't).
Thanks for pointing me in the right direction...