• Ii have created the procedure :

    CREATE PROC Test

    WITH ENCRYPTION

    AS

    SELECT *from tbl_Test

    Now this procedure is encrypted, but in SQL 2008 we can see it's execution plan too.

    I have attached a screen shot also