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?
Mark as Answer if you got right thing
Ansuman Padhy
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.
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......
Mark as Answer if you got right thing
Ansuman Padhy
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.
Ansuman Padh...
Member
7 Points
15 Posts
Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
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?
Ansuman Padhy
nikunjnandan...
Participant
872 Points
223 Posts
Re: Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
Jan 18, 2013 05:59 AM|LINK
Hii,
I think it's not possible if you lost your original sp.
Check in your daily backup or something else where put it.
Nikunj Nandaniya
My Blog
Ansuman Padh...
Member
7 Points
15 Posts
Re: Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
Jan 22, 2013 03:38 AM|LINK
Can anybody help me plz???????????
Ansuman Padhy
graciax8
Participant
751 Points
210 Posts
Re: Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
Jan 22, 2013 05:17 AM|LINK
Try using third party software like Optillect SQL Decryptor.
Hope this helps.
mycodepad.blogspot.com || TUMBLR
Ansuman Padh...
Member
7 Points
15 Posts
Re: Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
Jan 23, 2013 08:28 AM|LINK
This software doesn't work in Lan Connected Systems. This is only for singe user....
Ansuman Padhy
Chen Yu - MS...
All-Star
21569 Points
2493 Posts
Microsoft
Re: Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
Jan 23, 2013 09:41 AM|LINK
Hi,
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.
http://sqljunkieshare.com/2012/03/07/decrypting-encrypted-stored-procedures-views-functions-in-sql-server-20052008-r2/
If your stored procedure didn't exist in your instance, please tell us more information about your surrounding. Thanks.
Best Regards,
Feedback to us
Develop and promote your apps in Windows Store
Ansuman Padh...
Member
7 Points
15 Posts
Re: Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
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......
Ansuman Padhy
Mandeep Joon
Participant
1570 Points
382 Posts
Re: Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
Jan 28, 2013 09:38 AM|LINK
Hi,
May be it will help you.
http://download.cnet.com/Optillect-SQL-Decryptor/3640-10254_4-75300271-1.html
Mandeep Joon
Blog:- Hightechnology.
Ansuman Padh...
Member
7 Points
15 Posts
Re: Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
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.....
Ansuman Padhy
walllerry
Member
18 Points
8 Posts
Re: Ho to Decrypt an Encrypted Stored Procedure in SQL Server 2008 R2
Mar 21, 2013 06:43 AM|LINK
Hi,
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.