Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've just installed SQL Server 2008 R2 Express for local development, and it's flooding the Application Event Log with a seemingly endless barrage of trivia and drivel ("SQL Server is now ready for client connections. This is an informational message; no user action is required.").

MSSQL$SQLEXPRESS has pushed over 157 of these kind of messages into my event log in the past ten minutes and I'm getting a little tired of them overpowering the events that actually have something important they need to tell me.

Is there any way to turn off this firehose? Or at least slow it down to the point where SQL Server is only telling me about things I really need to know about instead of "starting up database 'tempdb'"?

share|improve this question
1  
I really need to know about Who knows what you really need to know about? You do. Make a custom event log view or filter. –  ta.speot.is Apr 26 '13 at 22:29

1 Answer 1

In the right hand pane of the Event Viewer, click on Create Custom View, and in the window that pops up, click on the Event Levels that you want. For example, you may want Critical, Error, and possibly Warning logs. Then, you can filter out the sources that you want as well.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.