title: SHOWPLAN permission denied in database 'tempdb'. in sql server 2008
body: <p>I have a query when I run the below query in Include Actual Execution Plan then it throws the following error :</p>
  
  <p>Execution Result :</p>
  
  <p>(1 row(s) affected)</p>
  
  <p>(89 row(s) affected)</p>
  
  <p>(1 row(s) affected)
  Msg 262, Level 14, State 4, Line 25
  SHOWPLAN permission denied in database 'tempdb'.</p>
  
  <p>Note : Before creating CLUSTERED INDEX on temptables it is working fine. after creating  CLUSTERED INDEX it was showing the above error. how can I see the execution plan for the below query any suggestions. </p>