how to decrypt the views & store procedure in sql server
That will greatly depend on your version of SQL server. There are plenty of examples out there on the net for each version.
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.
my point of view is, if you are a legal owner of the views or stored procedure, you should have access to the original un-encrypted source. If you are not the legal owner, this is an act of stealing and infringed of intellectual property rights.
No, my account has not been hacked. Thank you all for noticing this post.
My answer was supposed to go to another question where that OP wanted to know if there was a way to totally clear a database of all tables, regardless of FK-constraints.
No one has followed this question yet.