Post reply

Could I get the xp_ source code please

  • November 14, 2008 at 3:53 pm

    #215331

    The link to the code does not wok. I am hoping to source code in order to see if I can get around the export/import issue I am having.

    Thanks

  • November 17, 2008 at 9:29 am

    #899392

    Not sure what the article is (no link)

    but to get a source code of a stored proce (system or user)

    sp_helptext sp_who2

    Unless it's encrypted, it should give you the source code

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • November 17, 2008 at 9:32 pm

    #899670

    There are many XP_ extended stored procs that point to a DLL... and the source code for those DLL's isn't part of the SQL Server installation code...

    So, the answer is, you probably can't get the source code to the XP_ extended stored procs.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • November 18, 2008 at 7:42 am

    #899925

    Thanks for the replies. This thread was intended for the SQL 2000 DBA Toolkit Part 1 topic, somehow I messed up.

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

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