| Author |
Messages |
|
tdn0114@hotmail.com
 |
| 09/11/2001 4:29 AM |
 Quote
 Reply
 Alert
|
| How can I turn on the Security Audit to track user logins and logoffs? Where can I go to get this information after the audit is turned on? If this is not the way to track logins, does anyone have a script (or scripts) that I can use to track user logins to the database?
Thanks very much in advance!! |
|
|
|
|
Chip Andrews
|
| 01/01/2001 12:00 AM |
Quote
Reply
Alert
|
| You can use the Security Tab under server properties or by executing:
xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',N'AuditLevel', REG_DWORD,3
To see the logs look at \program files\microsoft sql server\mssql\log\errorlog or use Enterprise Manager - Management - SQL Server Logs
Chip |
|
|
|
|
|