Post reply

Decrypt Stored Procedure

  • March 18, 2016 at 6:16 am

    #317079

    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

    #1866127

    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!

  • March 20, 2016 at 10:51 pm

    #1866365

    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