is there a way to decrypt the StoredProcedure after Encryption in SQL server 2005

Question

is there a way to decrypt the StoredProcedure after Encryption in SQL server 2005

MsCode_Pro

Say Hey Kid

Points: 690
More actions
June 13, 2008 at 10:42 am

#381132

is there a way to decrypt the StoredProcedure after Encryption in SQL server 2005,
YoU CaN't LoSe WhAt YoU NeVeR HaD;)

Viewing 8 posts - 1 through 7 (of 7 total)

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

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 1

I don't think you can...You can encrypt the code but can't decrypt, so if you need to make changes to the sp you will need the orginal create script.

Gethyn Elliswww.gethynellis.com

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

There are methods to decrypt them. The problem (and I think why you're not getting any answers) is that a forum is a highly inadequate place to ascertain whether the request to decrypt this code is legitimate (stupid mistake where the op owns the code but has lost it), or if they're trying to break into someone else's code.

The incertainty and the impossibility of figuring out which is accurate is probably why noone wants any part of this question.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

MsCode_Pro Say Hey Kid Points: 690 More actions · Answer 3

ok So........., irealy can`t understand you obviously

i know how can decrypt Sps created by Sql2k but 2005 not

YoU CaN't LoSe WhAt YoU NeVeR HaD;)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

You can decrypt them. Both SQL 2000 and SQL 2005, though the methods are different.

A google search should dig up more information for you.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 5

I haven't seen a free tool for SS2K5, but I have seen some for sale.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 6

I just realized a mechanism did get published... Decrypt SQL Server Objects, SQL Server Magazine, August 2007, by Omri Bahat. If you're an on-line subscriber, you can access the SQL Mag web site to pull the article. Basically it's the same trick as by shoeboy for SQL Server 2000. The catch is you've got to come through the DAC (this is well known, as the other tools have to do this, too).

K. Brian Kelley
@kbriankelley

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 7

Omri also runs the North Va SQL Server User's Group. Can probably contact him there or at SQLFarms.