2000 Error log

• Kev

  Default port

  Points: 1435

  More actions

  June 24, 2008 at 8:20 pm

  #71617

  Hi

  I am trying to use xp_readerrorlog to extract the current error log for sql server 2k it reports 2 lines for some records does anyone have a script that will extract this 2nd line and place it with the 1st line.

  I would like it to be in the same format as the 2k5 xp_readerrorlog output

  Logdate , ProcessInfo, Message

  Thanks

  Kevin

  Kevin

• Wildcat

  SSCarpal Tunnel

  Points: 4774

  More actions

  June 25, 2008 at 11:26 am

  #834166

  Is there any difference in 2005 for sp_readerrorlog and xp_readerrorlog? (because I got the same result)

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  June 25, 2008 at 11:55 pm

  #834419

  [font="Verdana"]Hi,

  XP_Readerrorlog is an extended stored procedure.

  SP_readerrorlog is a SP which will call xp_readerrorlog inside it. You can use sp_readerrorlog for many things, refer the link below.

  The undocumented nature of sp_readerrorlog in SQL Server 2000

  [/font]

  Regards..Vidhya Sagar
  SQL-Articles