March 18, 2016 at 6:16 am
Hi,
I Created one Stored Procedure in SQL 2008 as 'WITH ENCRYPTION'. But i don't have back up of that stored procedure.
How can i decrypt that procedure please help me out......
March 18, 2016 at 7:03 am
if you connect locally via a Dedicated Admin Connection, you will be able to see the unencrypted definitions. you might have to enable the DAC just to conenct that way, though.
Redgates' SQL Compare will also decrypt objects for you, and there are other applications that will do the same, if you google a bit.
Lowell
March 20, 2016 at 10:51 pm
Check out the following link, it gives step by step description to decrypt encrypted data
http://sqljunkieshare.com/2012/03/07/decrypting-encrypted-stored-procedures-views-functions-in-sql-server-20052008-r2/ [/url]
Or use the following SQL Decryptor Tool to decrypt encrypted SQL Server stored procedure http://www.sqldecryptor.repair-sql.net/ [/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply