Sproc decryption of sql 2005 allowed in Compare but not Doc?

wtjoneswtjones Posts: 21
edited December 1, 2008 4:36AM in SQL Doc Previous Versions
SQL Doc can only decrypt sql 2000 procs as explained here:
you are documenting a SQL Server 2000 database that contains an encrypted user-defined function, stored procedure, trigger, or view and you have system administrator permissions, SQL Doc can decrypt the object and you can view its internal SQL.

However, views, stored procedures, functions, DML triggers, and DDL triggers that are encrypted in a SQL Server 2008 or SQL Server 2005 database cannot be decrypted. Therefore, SQL Doc cannot document the creation SQL for these encrypted objects.

It appears that SQL Compare can do this:
In SQL Compare version 7.1 (and later) you have the option to decrypt text objects in SQL Server 2005 and SQL Server 2008 databases created using the WITH ENCRYPTION option.

Will this be added to SQL Doc? In the meantime, would I be able to first use compare to decrypt and then have Doc spit out the procs?



  • Options
    I am afraid the ability to decrypt encrypted objects in SQL Server 2005 and 2008 is not available in SQL Doc but it is logged as a feature request in our tracking system and willl be considered for a future release.

    You will not be able to use SQL Compare to decrypt the objects to allow SQL Doc to document them either.
Sign In or Register to comment.