How can i decrypt an encrypted stored procedure?

Vikram ,

With Encryption keyword usually encrypts the stored procedure . You can either use dbforge to decrypt or you can use the below script .

dbforge - http://www.codeproject.com/Tips/353459/A-simple-hack-of-a-built-in-MS-SQL-Server-WITH-ENC

Run Script via DAC : https://www.mssqltips.com/sqlservertip/2964/encrypting-and-decrypting-sql-server-stored-procedures-views-and-userdefined-functions/

http://sqljunkieshare.com/2012/03/07/decrypting-encrypted-stored-procedures-views-functions-in-sql-server-20052008-r2/

Thanks,

Priyan

If you found this useful Please Accept this as Answer .