• HVPR (11/24/2009)


    can anyone know where the sql server stores the sql error log configuration settings info.

    There is SQL Server error log, not aware of "sql error log configuration settings info"

    Find the article below, would that help your case?

    Working with SQL Server Error Logs

    we want to monitor the sql error log settings so is it possible to monitor them.

    By default the value is between 6-99 error logs we can have... how can we monitor them and where does it store the config setting information in like(sys table,registry etc)..

    Would you like to view the error logs or view the settings? Either case, in the object explorer, under Management Node, on SQL Server Logs right click and select Configure or select View to view the Error logs.

    UPDATE: Updated the link to the blog post


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty