Extended Store Procedures

  • Is there a way to look a the code within an xp?

    Thanks

  • Maybe you could decompile, that would be about it.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • XP's are calling dll's to do the task....

    Prakash

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • Sorry, the xp dll's have a specific format internally that allow SQL to interact with them but as for looking at the code most likely will not be able to see much as the code is pretty well hidden and have not seen a decomlier (if you do find one that works be carefull as if you get caught you really can see a legal headache out of it). However, you can open the DLL in notepad and see some information that is not hidden, may help a little.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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