Post reply

xp_readerrorlog

  • September 19, 2011 at 1:17 am

    #390426

    Hi All,

    Just checked the content of sp_readerrorlog procedure and found that it executes xp_readerrorlog. When opened xp_readerrorlog I got the folklowing.

    "xpstar.dll"

    Can anyone tell me what exaclty happens when we execute 'sp_readerrorlog' ?

    How this dll is called and what it does to fetch us the error data.?

    (Since I used to be a coder before, I am aware about what's a DLL and how's it used etc;)

    Thanks in advance.

    San.

  • September 19, 2011 at 2:00 am

    #1383175

    Hi,

    If you want to know what exactly the DLL does in SQL server you can go through the below Link

    http://dll.paretologic.com/detail.php/xpstar

    2)To know about how SP_readerrorlog will works.

    http://www.mssqltips.com/sqlservertip/1476/reading-the-sql-server-log-files-using-tsql/

    Thanks,

    Rama Udaya.K

  • September 19, 2011 at 5:13 am

    #1383234

    Joy Smith San (9/19/2011)

    Can anyone tell me what exaclty happens when we execute 'sp_readerrorlog' ?

    It returns the contents of the errorlog filtered according provided parameters 🙂

    Joy Smith San (9/19/2011)

    How this dll is called and what it does to fetch us the error data.?

    1- DDL is called as shown on extended storedproc

    2- Since this is a DDL it is clear the piece of software is considered propietary by the vendor hence code is not available to the general public. My guess is that the DDL opens the desired text file, parses content, filters according to parameters and return result set back.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • May 29, 2012 at 3:52 am

    #1494061

    A good summary of 'xp_readerrorlog' can be found here:

    http://www.mssqltips.com/sqlservertip/1476/reading-the-sql-server-log-files-using-tsql/

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

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