We are not able to see the execution plan of encrypted stored procedure, if that is the case then there is the need of encryption keyword 🙂

If we use SQL Profiler and add performance -> "Showplan XML" or "Showplan text", then profiler displays "Encrypted text" when it is executing actual procedure.