sepknow
asked on
Log successful login and logout
How can I configure SQL Server 2000 to log successful login and logout?
login and logout from what? database?
ASKER
Yes.
Are you using Windows Auth, SQL Auth, or Mixed Mode?
Logon: http://msdn2.microsoft.com/en-us/library/bb326598.aspx
There is no log out trigger, can you catch it at your application?
There is no log out trigger, can you catch it at your application?
ASKER
Mixed Mode.
In SQL 2005, it can be done in the server setting,
but I am using SQL Server 2000.
In SQL 2005, it can be done in the server setting,
but I am using SQL Server 2000.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.