Hi,
Recently, I read one article about SQL Decryptor which explains the SQL Server encryption and decryption process. you can take help from it to get points clear about sql decryption for the encrypted database which included encryption of stored procedures, views, rules, etc.