Decrypting of stored procedures.

RyanG

I have had success in the past with Redgate's sql prompt decrypting of stored procedures.  Now I am getting the following error > Property TextHeader is not available.  I am running SQL Prompt v9.4.16.9097.  Options>Behvior>Decrypt encrypted objects is checked.  

Dan B

Hi Ryan,

I'm not sure if this is a Prompt error or a permissions issue, can you follow the instructions here and let me know if this resolves it for you.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ee82df77-50da-4a95-a3ba-43aa6257f1d2/property-textheader-is-not-available-for-storedprocedure?forum=sqlsecurity

RyanG

I am sysadmin.  I should have been hitting F12 from the query window with the proc highlighted.  I was using a right click ALTER on the procedure from Object Explorer.