Post reply

Error log table OR Stored Proc

  • September 22, 2008 at 1:07 am

    #94518

    hi

    Can any body tell which table/view/Stored Proc be used to see error log of database

    i dont want ot see the error log ,i want ot use only query/sp ???

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • September 22, 2008 at 1:20 am

    #874811

    sp_readerrorlog will show you the current error log for the server as a resultset.

    The error log's not stored in a table so there's no direct query. It's a file (called ERRORLOG) in the file system.

    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

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

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