Scan error log

• goher2000

  SSCertifiable

  Points: 5477

  More actions

  February 20, 2018 at 9:13 am

  #329422

  I am trying to get errors along with error codes,  looks like some of the error messages does not match with error code

  use tempdb
  CREATE TABLE errors
  (
      RowID int IDENTITY PRIMARY KEY,
      EntryTime datetime,
      source varchar(50),
      LogEntry varchar(4000)
  )

  insert into errors
  exec master..sp_readerrorlog 0

  select a.*,b.* from errors a, errors b where a.logentry like 'Error:%' and b.rowid=(a.rowid - 1) order by a.entrytime desc

  

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  February 20, 2018 at 9:19 am

  #1980486

  Try joining on  b.rowid=(a.rowid + 1)

  John

• goher2000

  SSCertifiable

  Points: 5477

  More actions

  February 20, 2018 at 9:28 am

  #1980489

  thanks, it works

  select a.*,b.* from errors a, errors b where a.logentry like 'Error:%' and b.rowid=(a.rowid + 1) order by a.entrytime desc