Read Error Log

• RaviShankar1234

  SSCommitted

  Points: 1647

  More actions

  January 20, 2011 at 4:18 pm

  #243996

  Hi all,

  As I am aware that we can read errorlog through sp_readerrlog and xp_readerrorlog and both these read all the records in the errorlog. But I wanted to know how can we read the errorlog for the last 1 hour?

  can any one let me know how this can be done?

  Thanks,

  Ravi

• Brigadur

  SSCrazy

  Points: 2097

  More actions

  January 23, 2011 at 11:58 am

  #1276994

  Hi,

  Maybe you already figured it out, otherwise Google gave me this nice article: Reading the SQL Server log files using T-SQL

  Seems the key is to use xp_readerrorlog, the parameters are explainded in the article.

  Cheers

• TakeITeasy

  SSC Enthusiast

  Points: 181

  More actions

  February 15, 2011 at 3:26 am

  #1286939

  Hi,

  You can specify the FromTime and EndTime in the extended stored procedure.

  see the syntax below.

  xp_readerrorlog 1,1,search1, search2, fromtime, endtime, asc/desc

  Thanks,