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