login's last access

Hi,
In SQL 7, is there a way to know when a (NT and SQL auth)
login last went into the SQL server?
Thanks,
dennisDennis,
SQL Server can log event information into ERRORLOG file for review by the system administrator. At a
minimum, you should log failed connection attempts to SQL Server and review the log regularly. When
possible, save these logs to a different hard drive than the one on which data files are stored.
But for this following should have been already configured which, enables auditing of connections in
SQL Server:
Expand a server group.
Right-click a server, and then click Properties.
On the Security tab, under Audit Level, click Failure/success/all.
You must stop and restart the server for this setting to take effect.
- Vishal