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

Posted on 2008-11-09
Last Modified: 2012-05-05

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.

Question by:Dextertronic
    LVL 31

    Assisted Solution

    by:James Murrell
    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
    LVL 9

    Accepted Solution

    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:
    LVL 10

    Author Comment

    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.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now