Post reply

SQL Server Error Log

  • August 19, 2013 at 5:56 am

    #297898

    Hi All,

    I am not able to see my Error Log in SQL Server, In Sql Server Instance Properties's Advance Tab Set Error Reporting = No. Can any body advice me how can we see this and what happened when we set Error Reporting = No.

    @ Regards

    Dharmendra

  • August 19, 2013 at 6:00 am

    #1642626

    Dharmendra JKT (8/19/2013)

    Hi All,

    I am not able to see my Error Log in SQL Server

    Where are you looking?

    In Sql Server Instance Properties's Advance Tab Set Error Reporting = No. Can any body advice me how can we see this and what happened when we set Error Reporting = No.

    This is the default, and it just means you won't automatically send a report to Microsoft if something fails.

    http://technet.microsoft.com/en-us/library/aa176600%28v=sql.80%29.aspx

  • August 19, 2013 at 6:19 am

    #1642634

    From Object Explorer, Management -> SQL Server logs. You can't turn off error logging.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 22, 2013 at 6:06 am

    #1643857

    thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply