• just use with encryption option which works well with Stored Procedures, Triggers, Functions and Views definitions.

    one example :

    CREATE PROCEDURE usp_mysp
    WITH ENCRYPTION
    as
    BEGIN
       // sp code
    END; 

    try to run the command :
    sp_helptext usp_mysp
    it will give message that text is encrypted.

    hope that helps

    matin