Encryptin stored procedures

Is there any way to generate a script of an encrypted stored procedure?
I supose that itsn't, so, is there are any way to encrypt a script so that I
can generate a encrypted stored prodcedure?Search google for "decrypt SQL stored procedure"
Not sure what you mean by the second part. Specifying WITH ENCRYPTION for
your CREATE PROCEDURE script will generate an encrypted stored procedure but
the script itself is plain text.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gaby" <msdn@.rmya.com.ar> wrote in message
news:OcjhQ5CvEHA.944@.TK2MSFTNGP11.phx.gbl...
> Is there any way to generate a script of an encrypted stored procedure?
>
> I supose that itsn't, so, is there are any way to encrypt a script so that
> I
> can generate a encrypted stored prodcedure?
>|||Hi Gaby,
I am just checking on your progress regarding the information that was sent
you! Have you tried the google as MVP suggested you? I wonder how the
testing is going. If you encounter any difficulty, please do not hesitate
to let me know. Please post here and let me know the status of your issue.
Without your further information, it's very hard for me to continue with
the troubleshooting.
Looking forward to hearing from you soon
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!