decrypt sql server 2005 sp

  • hi,

    how can i decrypt a stored procedure in sql server 2005?

    THX

  • You need to be connected via the DAC. As to the exact means, I'd suggest you Google for it. No offense, but that's not something I'd post in a forum.

    K. Brian Kelley
    @kbriankelley

  • go there u will find a good one.

    http://www.sqlfarms.com

    ..>>..

    MobashA

  • avipenina (5/21/2008)


    hi,

    how can i decrypt a stored procedure in sql server 2005?

    THX

    I'm curious... where is your source code? Or are to trying to break in on someone else?

    --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)

  • i lost my source code to a few encrypted SP

  • Ok... thanks...

    Like the others have said, if you do a Google or other search, you'll find several articles on how to do this. It's just not something that most of us will post and I've not had to do it before.

    --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)

  • never mind, there is even tools for it or u can use scripts.

    i dont think it is that big deal!! as long as there is tools out thier u can just buy...

    ..>>..

    MobashA

  • the tools cost money.i try the script that i found in google but all they does is to delete the SP that i want to decrypt.

    can you point me to article on how to do that?

    THX

  • search more u cannot miss it.

    ..>>..

    MobashA

  • ok i found script that use the DAC connection to decrypt SP and it's works great.

    THX

  • can you share the link / the source, please?!

  • How about you script out all of the stored procedures into one file, then do a replace on:

    AS

    Change it to:

    WITH ENCRYPTION

    AS

    Just use notepad or any other text editor to do it.

  • This isn't something we typically post on the forums. However, there are tools readily available on the Internet if you do a search using Google.

    K. Brian Kelley
    @kbriankelley

  • Hi, i buy a software called sql decryptor searching in the cnet.com web site by US$ 9.95 and resolve my problem.

    😉

  • Mad-Dog (5/26/2008)


    ok i found script that use the DAC connection to decrypt SP and it's works great.

    THX

    Heh... two way street here, MD... share your solution. Where did you find the script? Cough up a link, please.

    --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)

Viewing 15 posts - 1 through 15 (of 30 total)

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