Post reply

errorlog basics

  • March 15, 2010 at 1:26 am

    #137889

    Dear All,

    I have seen in SSMS in left hand side there is two option og log.

    1. SQL Server Logs under Managment

    2. Error Logs Under SQL Server Agent

    what is difference between them .

    which operation will written in Sql Server Log but not in Error Logs

    Thanks in advance

  • March 15, 2010 at 1:34 am

    #1133542

    The one under SQL Agent gives log details about scheduled jobs alone.

    The one under Manangement->Sql Server logs is the one that stores SQL error logs. I prefer to use sp_readerrorlog sp to read SQL Server error log as its faster to do it that way.

    Regards,
    Raj

    http://Strictlysql.blogspot.com

Viewing 2 posts - 1 through 1 (of 1 total)

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