Brandie Tarvin (1/31/2011)
Wouldn't the security log give that information?
It might, though depending what else is on the box there may be too much noise in there to make sense.
If SQL is set to audit logins success as well as login failure, then the messages should appear in the output of the running SQL process (and in the error log)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability