Kindly Clarify: Execution plan is not showing [Resolved]

Posted by Jasminej under Sql Server on 5/14/2012 | Points: 10 | Views : 922 | Status : [Member] | Replies : 4
Execution plan is not showing the graphical status.

1. I have selected "Actual Execution Plan"
2. I am running a stored procedure in the same session.

But, Graphical plan is not showing. I have only two tabs (Results and Messages). But not "Execution Plan" tab

what would be the reason ?

thank you




Responses

Posted by: Pandians on: 5/14/2012 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
May be your Stored procedure been Encrypted!

Because, Execution plan is not displayed for Encrypted objects!

It'll not throw any Error. But, will not show the "Execution Plan" graphical tab!


Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jasminej on: 5/14/2012 [Member] Starter | Points: 25

Up
0
Down
How to identify whether the procedure is encrypted or not ?

Thank you

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pandians on: 5/14/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
It show you whether your stored procedure is encrypted or not
Use <Database>

Go
Select Case OBJECTPROPERTY(Object_id('<ProcedureName>'),'IsEncrypted') When 1 then 'It has been encrypted!' Else 'Not encrypted' End [Status]
Go
Note: replace your stored procedure name '<ProcedureName>' and Database Name '<Database>'

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jasminej on: 5/14/2012 [Member] Starter | Points: 25

Up
0
Down
yes. the stored procedure was ENCRYPTED.

thank you very much

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response