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.
Comments
2 comments
-
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
-
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.
Add comment
Please sign in to leave a comment.