CREATE PROCEDURE ... WITH ENCRYPTION 

Keep in mind that it can be easily decrypted. See http://optillect.com/products/sqldecryptor/overview.html, for example

>
>I hear my friend said , sql server can encryption the stored procedurs....
>if double click stored procedurs in sqlserver, it will say encryption , then can't see the code....
>How to encryption the stored procedurs?
>