Could I get the xp_ source code please

• ricva

  Default port

  Points: 1404

  More actions

  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

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  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

• Jeff Moden

  SSC Guru

  Points: 1004561

  More actions

  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)
  

• ricva

  Default port

  Points: 1404

  More actions

  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.