Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 21, 2013 06:43 AM by walllerry
Jan 18, 2013 05:49 AM|LINK
Hello Every Body,
I am Using Sql Server 2008 R2. I have a Stored Procedure with name USP_ANSU_TAB which is Encrypted. I Lost the code of that Stored Procedure. Now i want to do Some changes in that Stored Procedure. So can anyone plz help me how
to Decrypt that Stored Procedure?
Jan 18, 2013 05:59 AM|LINK
I think it's not possible if you lost your original sp.
Check in your daily backup or something else where put it.
Jan 22, 2013 03:38 AM|LINK
Can anybody help me plz???????????
Jan 22, 2013 05:17 AM|LINK
Try using third party software like Optillect SQL Decryptor.
Hope this helps.
Jan 23, 2013 08:28 AM|LINK
This software doesn't work in Lan Connected Systems. This is only for singe user....
Jan 23, 2013 09:41 AM|LINK
Do you have that encrypted stored procedure in your instance? Could you use that encrypted stored procedure? If you have that stored procedure but you couldn't modify it as it has encrypted, you could follow below article method to decrypt your stored procedure.
If your stored procedure didn't exist in your instance, please tell us more information about your surrounding. Thanks.
Jan 28, 2013 08:10 AM|LINK
I am working in a network based work group. All systems are connected through Lan. One of my SP is Encrypted by some one else. I don't know who does this. Now i want to change the code of that SP. But i can't. tell me how to do that. Thanx in advance......
Jan 28, 2013 09:38 AM|LINK
May be it will help you.
Jan 29, 2013 03:24 AM|LINK
No this software is also not usefull as it work in personal computer not in server based network.....
Mar 21, 2013 06:43 AM|LINK
This quest is easy to resolve with our unfailing software i.e., SQL Decryptor Software. If you have
encrypted an object definition in your database by specifying WITH ENCRYPTION option, and due to some reason you cannot restore its original T-SQL body, the SQL decryptor will easily do it for you. So, try it.