how to decrypt the views & store procedure in sql server
There are two ways of doing it, the 'ALTER PROCEDURE to derive the key' kind of way, and the 'generate the key from the relevant parts of the database' kind of way. I would advise trying to use the latter, as that means you don't actually make any changes to the database in order to perform the decryption.
Another thing, on SQL 2005+ you have to be connected to the DAC in order to be able to get to the encrypted text of the SQL module.
No one has followed this question yet.