Query sys.procedures and use the OBJECTPROPERTY function with the 'IsEncrypted' property.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability