Post reply

2000 Error log

  • 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

  • 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)

  • 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

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

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