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?