Prevent SQL events of type "Information" being logged in the Application Event log.


Is there a way to configure SQL to only log events of type "Error" and "Warning" to the Applicaiton Event log?

The end goal is to eliminate the constant dribble of SQL Information events to the Application  log.

LVL 10
TristanIT ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James MurrellProduct SpecialistCommented:
use but i have seen a member of staff use
1) Go to the SQL Server Properties via Enterprise Manager (i.e. right
click the server and go to properties)
2) General Tab
3) Startup Parameters
4) Add new startup parameter--> /T3226
5) Apply / close dialog
6) Restart SQL Server instance
it appears this may not be possible

on the other hand, if you setup a limit to the size of the event log you will hardly retain more then absolutely needed minimum of events on hand, in case you need to troubleshoot an issue. So, the impact of accumulating messages can be effectively managed. I understand that some of the messages prompted this reaction, and to be 100% honest, I do not know why it is done this way. But I do know first hand that trace collecting applications normally try very hard to provide features to gather data accurately and with minimal impact on system, while rarely do provide for in place removal of entries. Those normally do offer some extension to load trace into a file or a database table to maintain the content to the users heart desire. This approach is not specific to any specific product but a mindset of all tracing applications I can recall off hand.

If you would like to have a better picture of events accumulated over time you may want to look at Microsoft System Center Operations Manager 2007, available here for download and evaluation:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TristanIT ManagerAuthor Commented:
I'm going for the -n start up option.
These SQL databases do nothing but drive Arcserve databases and as such I can live without their constant drivel.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.