Could I get the xp_ source code please

  • 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

  • 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

    SQLServerNewbie MCITP: Database Administrator SQL Server 2005
  • 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)
    Intro to Tally Tables and Functions

  • 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