Kindly Clarify: Execution plan is not showing [Resolved]

Posted by Jasminej under Sql Server on 5/14/2012 | Points: 10 | Views : 1612 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

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

0	yes. the stored procedure was ENCRYPTED. thank you very much Jasminej, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts