If you have encrypted an object definition in your database(s) by specifying WITH ENCRYPTION option, and by some reason you cannot restore its original script, the SQL Decryptor will easily do it for you absolutely FREE. Save your time and funds on restoring lost definitions and stay happy with our products.
Features: Supports all versions and editions of the Microsoft SQL Server: SQL Server 2000, SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2; Decrypts all possible object typesStored procedures (including numbered procedures and replication filters), functions (scalar, inline and multistatement table-valued), triggers (on tables, on views, on databases, and on server instances) and views. No DAC connection required Similar tools compel you to use Dedicated Administrator Connection mode to decrypt an object, which may lead to certain difficulties with reconfiguring the whole server.
SQL Decryptor does not require this mode, but does not prohibit to use it, because you can save some time while decrypting objects in large databases. Object Explorer like in SQL Management Studio You can do everything in a familiar way: connect to as many server instances as you like and browse all available databases. Syntax highlighting A build-in text editor allows you to see the original object definition with syntax highligthing, which facilitates reading of source code. Saving definition to file You can save every decrypted definition to a file with UTF-8 encoding, which preserves all national characters. Overhead minimizing All definitions are placed to a programs cache after first opening, so next time you want to examine the same definition, the cache will be used. Highly responsive user interface SQL Decryptor performs everything asynchronously, thus you can instantly cancel any long-term operation and you will never see the program hung.
I just used this I thought I needed to give credit where it is due. The download wanted to install about 3 other apps that I did not want. I just kept clicking the decline button until we got to the main app. This is quick and does everything I was hoping, Decrypted an Sproc hidden and encrypted by a colleage.
No cons ... unless you are expecting the world in a wine glass. This does decryption of Sprocs..... maybe more but I didn't try.
It works...... can't get more of a summary than that. BTW: was working on a 2008R2.