How can we help you today? How can we help you today?

decrypt objects

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.
dbaman7
0

Comments

1 comment

Sort by
  • 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
    Paul Stephenson
    0

Add comment

Please sign in to leave a comment.