Decrypt Stored Procedure

  • 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......

  • 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • 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