Decrypt a stored procedure

Question

Decrypt a stored procedure

SQLWinther

SSCertifiable

Points: 6294
More actions
March 5, 2009 at 2:03 am

#128780

All our procedures as encrypted in our production environment and now we have lost one of the procedures that we need from all other environments except production. We really need to get it back to a decrypted format. Anyone have an idea, or even a sample?
/Håkan Winther
Senior Development DBA
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform

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

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

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

Search google. You should find some links to products that do that (I don't think any are free)

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

SQLWinther SSCertifiable Points: 6294 More actions · Answer 2

This is what SQL Server books online say about encryption:

ENCRYPTION

Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output of the obfuscation is not directly visible in any of the catalog views in SQL Server. Users that have no access to system tables or database files cannot retrieve the obfuscated text. However, the text will be available to privileged users that can either access system tables over the DAC port or directly access database files. Also, users that can attach a debugger to the server process can retrieve the decrypted procedure from memory at runtime. For more information about accessing system metadata, see Metadata Visibility Configuration.

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform

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

Yup. That's correct.

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

Dugi SSCoach Points: 17998 More actions · Answer 4

Also you have many little applications that you can decrypt easily store procedures!

SQL Decryptor is one of them ...try in Google

Have a nice decrypting!

Dugi

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

SQLWinther SSCertifiable Points: 6294 More actions · Answer 5

GilaMonster (3/5/2009)
Search google. You should find some links to products that do that (I don't think any are free)

Thanks for your tip! 🙂

I found a lot of samples by google and a lot of them are free.

I think this post will do the trick, but i havent tried it yet:

http://span.com.my/forums/thread/551.aspx

/Håkan Winther

(Google is a perfect tool to prevent us from reinventing the wheel)

/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform

Optillect Team Grasshopper Points: 11 More actions · Answer 6

We strongly recommend to use our freeware named SQL Decryptor for this purpose. We guarantee that you will easily restore your definition.