Sunday, February 26, 2012

Event Log SQL 2000 on windows 2003

My Event log is getting filled with SQL event logs of login - how do I turn
this off?EM, right-click your server, properties, security setting.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lindsay Keith" <keith@.highintegritysolutions.com> wrote in message
news:10nsqcjj2g5ph39@.corp.supernews.com...
> My Event log is getting filled with SQL event logs of login - how do I turn this off?
>
>|||Lindsay,
Right click on the server in enterprise manager, click on the security
tab, then change the audit level to whatever you desire. I recommend you
leave it at Failure for a production system as a minimum, but I
personally prefer to log all activity.
You can change the event log size in Event Viewer, and you can tell it
to write over old log records so it doesn't fill up. I usually expand
mine to at least 10MB.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Lindsay Keith wrote:
> My Event log is getting filled with SQL event logs of login - how do I turn
> this off?
>
>

No comments:

Post a Comment