• You can also use with encryption when creating the temp stored procedure.

    Interestingly in SQL 2012 when the encrypted stored procedure is created the SQL code is viewable in profiler, unlike previous SQL versions... A bug??