How Do I configure error log settings?

I would like to turn off error logging, or instruct SQL to overwrite log files.  Do you know how I can do this using SQL 2005 express and Management Studio Express?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Cedric_DConnect With a Mentor Commented:
In SQL Server Configuration Manager, dbl-click on "SQL Server" service, go to Advanced tab, and add three symbols ";-n" to Startup Parameters, then restart service.

But this will eliminate only Windows Event Logging.
As I know, you cannot prevent SQL Server to create ERRORLOG files.
But you can "wipe out" any information from them by calling
DBCC ERRORLOG    seven times :)

Are talking about error logging or  transaction logging?  To my knowledge, errors are typically returned to the application for the application to write in an error log that would be handled in your application.

Transaction log files on the other hand are part of the backup/restore strategy of the database.  To turn them off,
alanrogerson2Author Commented:
Every few seconds an entry is being made in both the event viewer application log and the sql log file in program files/SQL Server

I would like to turn this off.
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Anthony PerkinsCommented:
Can you tell us what is that entry in "the event viewer application log and the sql log file"?
Anthony PerkinsCommented:
Also, when you get a chance the following questions appear to have fallen through the cracks and are now considered abandoned:

1 08/28/2007 500 Delphi and Web Application ... Open Delphi Programmi...
2 08/02/2007 500 Display Rows as columns usi... Open SQL Server 2005
alanrogerson2Author Commented:
it is a failed logon attempt.  I am using a hosted server on a standard SQL server port so many ip addresses are trying to get into the server but are failing.  I would like to stop logging failures.  

Thanks for the reminder about the open questions.
So these are hacking attempts that are failing?   Actually this happens to me to (I will never implement a hosted server on the default ports again !!!! :)  ).   I look forward to hearing if anyone has a solution....
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.