Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Audit Level / Login Alerts

Author  Topic  t78 Starting Member 1 Post Posted - 2009-09-21 : 11:20:25 hi all, I've been doing some investigation on reporting of Login attempts and the Audit Level setting. I get that if Audit Level is set to "all" then both successful and failed login attempts appear in the SQL Error Log. what I'm not too clear about is what events occur. eg - if Audit Level is set to "none", will a successful Login still trigger an alert? (assuming one is set on that event) this is for SQL2000 + 2005. any thoughts? cheers!