decrypt objects

dbaman7

I see that SQL Prompt 5 can now decrypt encrypted objects. How does this feature work? I created a simple stored procedure with encryption but right clicking in management studio does not have an option to decrypt when trying to script the create procedure.

Paul Stephenson

Hi dbaman7,

SQL Prompt 5 Pro will decrypt the stored procedure when you press F12 on its name in a query window to Script as ALTER (or right-click and choose from the menu).

You will also see the decrypted script if the encrypted procedure appears in the code-completion drop-down, and you click on it to bring up the little popup.

Hope this helps,
Paul