igsri (11/27/2010)
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
The screen shot doesn't show an execution for the stored procedure: it shows the execution plan for a batch which calls the stored procedure, with the execution of teh stored procedure itself omitted (because the SP was encrypted).
Tom