decrypt store procedures in MS SQL 2000

[Tak Man]

I am looking for a way to script out encrypted store procedures.
In MS SQL 7.0 we use "WITH ENCRYPTION" before sending the scripts.
This no longer can be done as it seems there is no way to script out from
database once it is encrypted in MS SQL 2000.

Anyone know how to script out if store procedure is encrypted?

thanks in advance,
Tak

[Tim Ellison]

No. That's the whole purpose of encrypting, so one cannot read the lines in
syscomments.

-Tim

"Tak Man" <tman@cogsdale.com> wrote in message
news:3ea92c3b$1@tnews.web.devx.com...
>
> I am looking for a way to script out encrypted store procedures.
> In MS SQL 7.0 we use "WITH ENCRYPTION" before sending the scripts.
> This no longer can be done as it seems there is no way to script out from
> database once it is encrypted in MS SQL 2000.
>
> Anyone know how to script out if store procedure is encrypted?
>
> thanks in advance,
> Tak