• Not an SQL solution, but it does the job of encryprting all the procedures.

    http://www.codeproject.com/Tips/239100/Encrypting-all-the-Stored-Procedures-of-a-Database