After publishing of my book “SQL Server Secret Diary” one of my friend has asked me a good question about decryption of encrypted objects in SQL Server.
I would like to share my answer to you all.That is in SQL server unfortunately there is no simple way to decrypt the code. And it is a hard to do this using codes.
But,there is a possible way to solve this problem is using “Third party tool”.There is number of tool are available in online to solve this problem.
I tried one of the third party tool called “DMT SQL Decryptor 3″ in following url http://www.bestshareware.net/downloading/dmt-sql-decryptor.htm
Using this tool you can easily get the encrypted objects like (Stored Procedure,View,Functions,..).