Anyway to decrypt an encrypted sql server stored procedure?

Question

Hi There,

I have a couple of ms sql server (2000) stored procedures encrypted by ex-employee long time ago and things were okay until we need to change it a bit.... is there any way at all to retrieve the source? Or rewrite is the only option?

Thanks a lot.

Answer 1

If your time is worth about $99, then this tool may do the job for you.
http://www.elitude.net/sql-decryptor.html

Answer 2

As a rule: In order to decrypt anything you should have the key used during encryption

Answer 3

Or for free (Google is your friend):

http://searchsqlserver.techtarget.com/tip/1,289483,sid87%5Fgci1056869%5Fmem1,00.html

Answer 4

We strongly recommend to use our freeware named SQL Decryptor for these purposes. Check it out on our website: http://optillect.com/products/sqldecryptor/overview.html

As a rule: In order to decrypt anything you should have the key used during encryption

Not this case, SQL Server uses database's GUID and object's ID as a key and deprecated RC4 for encryption. As simple to encrypt as simple to decrypt :)