What are the challenges you face when working across database platforms? Take the survey
Options

decrypt objects

dbaman7dbaman7 Posts: 2
edited January 26, 2011 9:48AM in SQL Prompt Previous Versions
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.

Comments

  • Options
    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
    Project Manager, Red Gate
Sign In or Register to comment.