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.
| Author |
Topic |
|
bryan42
Starting Member
28 Posts |
 Posted - 2011-12-29 : 15:25:18
|
| Is there a way to stop SQL Server from including all successful login records from the ERRORLOG file? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-29 : 15:45:24
|
| That doesn't happen by default, so someone must have configured it that way. First I'd check and see why that was done.Object explorer -> right click the server and select properties. Go to security and change the option from Audit successful and failed logins to Audit failed logins--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
How to turn off 'successful login' in errorlog