Post reply

decrypt sql server 2005 sp

  • May 21, 2008 at 11:06 am

    #122165

    hi,

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

    THX

  • May 23, 2008 at 8:38 pm

    #819959

    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

  • May 24, 2008 at 2:27 pm

    #820015

    go there u will find a good one.

    http://www.sqlfarms.com

    ..>>..

    MobashA

  • May 24, 2008 at 6:13 pm

    #820036

    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)
    Intro to Tally Tables and Functions

  • May 25, 2008 at 12:14 am

    #820049

    i lost my source code to a few encrypted SP

  • May 25, 2008 at 8:49 am

    #820060

    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)
    Intro to Tally Tables and Functions

  • May 25, 2008 at 11:51 pm

    #820108

    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

  • May 26, 2008 at 12:06 am

    #820110

    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

  • May 26, 2008 at 12:17 am

    #820112

    search more u cannot miss it.

    ..>>..

    MobashA

  • May 26, 2008 at 1:28 am

    #820123

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

    THX

  • June 10, 2008 at 3:12 am

    #826496

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

  • June 12, 2008 at 5:21 am

    #827750

    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.

  • June 12, 2008 at 7:20 am

    #827823

    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

  • December 3, 2008 at 5:06 am

    #906761

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

    😉

  • December 3, 2008 at 7:22 pm

    #907297

    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)
    Intro to Tally Tables and Functions

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

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