Encrypted SP's

Hi,
How can I do to desencrypt a encrypted SP '
Thanks
Richard_SQLHi Richard,
Use ALTER PROCEDURE, and remove WITH ENCRYPTION parameter.
--
Thanks
Yogish|||Although I can fully understand why you would want to
encrypt your SP its basically a waste of time. The reason
is that its reasonably easy to decrypt them.
If you want proof have a look on Google.
BTW Yogish is correct
Peter
"Facts are stupid things."
Ronald Reagan
>--Original Message--
>Hi,
>How can I do to desencrypt a encrypted SP '
>Thanks
>Richard_SQL
>.
>|||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...
> > Hi,
> >
> > How can I do to desencrypt a encrypted SP '
> >
> > Thanks
> >
> > Richard_SQL
>
>|||> 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. :-)