How to decrypt stored procedure in sql?

Question

For the security reason we encrypt stored procedure by using With Encryption but my question is how we decrypt it for further modifition

Andrew Jackson · Answer

great Share! you can use XOR decryption process see here: https://www.systoolsgroup.com/sql-backup-recovery.html

Bikesh Srivastava · Answer

Hi, You can prefer this link. https://www.mssqltips.com/sqlservertip/2964/encrypting-and-decrypting-sql-server-stored-procedures-views-and-userdefined-functions/

Vasanth Natarajan · Answer

Hi., I have resolved this problem. My Solution: use tool SQL Compare. You must create one database to compare sql script. Return result script sql is decrypted. http://www.red-gate.com/products/sql-development/sql-compare/

Afzaal Ahmad Zeeshan · Answer

As already suggested, using the key which was used for encryption. You must have shared some of the password-like credentials there. What were they? Use them to get the data back.

Subash · Answer

Afzaal Ahmad Zeeshan Thanks for your Reply but My Question is how we decrypt the already encrypted stored procedure in Sql

Subash · Answer

Thanks to Share your Experience ketan borsdiya

ketan borsdiya · Answer

No, I tried so many things but I didn't get any solution.. It may be possible to available in newer version of SQL Server.

Subash · Answer

Thanks Kethan is there any special way to decrypt it?

ketan borsdiya · Answer

Hi Subash, For modification in encrypted stored procedure you have to Paste whole procedure and remove with encryption after that alter procedure. After modification rewrite "With Encryption" and alter it.

Afzaal Ahmad Zeeshan · Answer

You can perform the encryption and decryption of the data using the same IV and the Key that is being used for the encryption. If you don't have that key and that IV you may not be able to get the stored procedure back. I have written an article that covers the encryption and decryption of the data ( one thing to note here is that encryption doesn't have to be with string text, it basically works on bytes of the data ). You should consider reading the post here, on C# Corner at, http://www.c-sharpcorner.com/UploadFile/201fc1/guide-for-building-C-Sharp-apps-on-ubuntu-cryptographic-helpers/. Now what you should do is to get the Key and IV of the encryption string from the security team of your development environment. Once you get that, you can decrypt the bytes of data ( of the stored procedure ) and get the data back to update the logic of that function. public static string Decrypt( byte []data) { string message= null ; //Instantiatethealgorithm using (varrjndl= new RijndaelManaged()) { //Setuptheproperties rjndl.Key=key; rjndl.IV=iv; //Createthememorystreamwiththebytesofdata using (MemoryStreamstream= new MemoryStream(data)) { //Createthestreamwiththedecryptors using (CryptoStreamcStream= new CryptoStream(stream,rjndl.CreateDecryptor(),CryptoStreamMode.Read)){ //Createastreamreaderforthecryptostream using (StreamReaderreader= new StreamReader(cStream)) { //Readthedatatotheend. message=reader.ReadToEnd(); } } } } //Returnthemessage. return message; } This code would do the trick (it was taken from that article of mine). All this needs is the IV and the key for your algorithm.

How to decrypt stored procedure in sql?

Answers (10)