Retrieving date/time from Sql Server system tables
A login generates an "audit login" SQL Server event. You can use SQL
Profiler to log audit login and logout events to a file.
Kindest regards,
Simon Taylor
Quote:
> I am interested in logging user activity, such as login date/time, and
> logout date/time. I know how to access the users in the SysUsers
> table, but there are no date/time fields in that table. How would I
> go about keeping track of login activity via the system tables
> (programatically that is)? Thanx....
