March 2, 2018 at 6:13 am
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.)
March 2, 2018 at 9:00 am
SQL Prompt decrypts the procs
March 2, 2018 at 9:36 am
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...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply