Encrypted SP's

Hi,
How can I do to desencrypt a encrypted SP ?
Thanks
Richard_SQL
Hi Richard,
Use ALTER PROCEDURE, and remove WITH ENCRYPTION parameter.
Thanks
Yogish
|||Search google for "decrypt stored procedure" (not desencrypt).
http://www.aspfaq.com/
(Reverse address to reply.)
"Richard_SQL" <Richard_SQL@.discussions.microsoft.com> wrote in message
news:37F2B8F7-883F-43DD-8E6C-1225147EB0AD@.microsoft.com...
> Hi,
> How can I do to desencrypt a encrypted SP ?
> Thanks
> Richard_SQL
|||Thanks for your help. Sorry by my english.
Richard
"Aaron [SQL Server MVP]" wrote:

> Search google for "decrypt stored procedure" (not desencrypt).
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Richard_SQL" <Richard_SQL@.discussions.microsoft.com> wrote in message
> news:37F2B8F7-883F-43DD-8E6C-1225147EB0AD@.microsoft.com...
>
>
|||> Thanks for your help. Sorry by my english.
No need to apologize, just wanted to make sure you were searching for the
right word, that's all. :-)