SQL Server Performance Forum – Threads Archive
All connections being logged in errorlogHi
my "Current log" has grown beyond the 5 meg mark by a little and can not be viewed – just hangs until I force quit EM. When I look at the physical log at sqlserverlogs I see every single connection to the DB is being logged. Why is that and can I stop it?
your question is not clear to me , would u plz descibe it properly ! 1) is it that you restrict growth of T-Log ? – you can reset it from 5MB to % or MB
2) If your login / user’s login entry is logged ,that means theirs a audit enable
Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami
Ditto I don’t understand the problem, but restarting the SQL service will generate a new "current log".
Yea change the audit level from log all to log failure only.
Audit level can be changed on the instance properties security tab. I believe it requires an instance restart for the new setting to take affect.