the function below is for SQL 2000 only; if you run it on 2005/2008/R2, all it does is drop teh encrypted procedure, but does not recreate it.
bjhogan (12/15/2010)
Check out this post for decrypting stored procedures.http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/30622/
Lowell