One note of caution. Save the original text of the stored procedure before encrypting it, as there is no straightforward way to decode the encrypted text. One hack is to attach a debugger to the server process and retrieve the decrypted procedure from memory at runtime.

Check out the below linkhttp://www.sqlservercurry.com/2008/02/how-to-encrypt-stored-procedure-in-sql.html