MS SQL Server 2000 and later versions have the capability to encrypt database objects codes to protect them from unauthorized access which I discussed in my last article. To revert the encryption, you’ll have to restore it from your unencrypted backup of the code. If you don’t have one, then SQL Decryptor is what you need.
SQL Decryptor is a lightweight tool to easily restore original script and manage encrypted SQL server object definitions. It can decrypt all MS SQL Server versions, including, SQL Server 2000, SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. You can either connect to a local or remote SQL database. All you need is Windows account or SQL account that has access to the target database server and these encrypted objects.
Once your successfully connected on the desired database, you are presented with a interface similar to Visual Studio 2010 where you can explore the encrypted objects.