Referencing to the bellow link

http://blog.sqlauthority.com/2008/11/01/sql-server-stored-procedure-with-encryption-and-execution-plan/

here the example

CREATE PROCEDURE #RegularSP

AS

SELECT TOP 10 City

FROM Person.Address

GO

/* Create SP with Encryption */

CREATE PROCEDURE #EncryptSP

WITH ENCRYPTION

AS

SELECT TOP 10 City

FROM Person.Address

GO

/* Execute SP - Execution Plan Tab shows up */

EXEC #RegularSP

GO

if create the stored procedure like above and execute the #RegularSP then it will show the executio plan and if we execute the #EncryptSP then the execution plan will be disappear.

Yousaf Khan