SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Decrypting encrypted stored procedures, easier way?


Decrypting encrypted stored procedures, easier way?

Author
Message
jasona.work
jasona.work
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45353 Visits: 16888
One of my customers has a slew of encrypted stored procedures. Worse, they *don't* have the original create scripts, so right now they're flailing in the dark when they have a problem with one of these procedures either not working, or not returning what they expect...
And, even worse, the original developer(s) of the encrypted procedures are no longer around to even ask about these procedures...

Now, I know it's possible to decrypt the procedures (albeit, I think, imperfectly) using the DAC and SQLCMD, but, is there an easier way?

Purchasing software that can do it might be an option, although with the restrictions on what we can or can't install it may not be an option...

The main reason I'm looking for an easier way to do this is, they've got a rather large number of encrypted procedures (not sure of the count off the top of my head.)
DesNorton
DesNorton
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19862 Visits: 8650
SQL Prompt decrypts the procs


How to post data/code on a forum to get the best help.
Make sure that you include code in the appropriate IFCode tags.
jasona.work
jasona.work
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45353 Visits: 16888
DesNorton, thank you. I thought when I'd puttered with the trial of Prompt, it would do that, I just re-trialed it on my lab PC and it does seem to the trick.
Presuming the procedure is written "well."
I have one in my test lab I threw together without a BEGIN / END, and Prompt won't get the actual query, while another which does have the BEGIN / END it will.

I'm going to throw this out as a suggestion to the customer, it would make both their lives and my life easier...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search