Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2013-03-11 : 08:48:32
|
| hiwe are exetiong Stored proceduer on Sql server 2008.stored proceduere exetting throuth temp tables and table varibles.lot of time consuming for execution. if sp having temp tables and table varibles then how to know the displsy estimated Execution plan for indexes.i have selected sp and right click selected by estimated executioon plan it is showing error. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-03-11 : 11:53:46
|
| what is the error message?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-11 : 12:36:04
|
| i think you may not have rights to view execution plan ie getting error showplan permission denied in databaseif thats the case ask the sysadmin to grant you the right------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-03-12 : 12:58:31
|
| If it's a showplan denied error - request a : GRANT SHOWPLAN TO UserNameJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
How to identity Display Estimated Executioon plan