SHOWPLAN permission denied in database 'tempdb'. in sql server 2008
sql-server, sql-server-2008
Solution
Get an admin to run the following in the `tempdb`:
GRANT SHOWPLAN TO <UserName>
GO
where `<UserName>` is your username.
Problem
I have a query when I run the below query in Include Actual Execution Plan then it throws the following error : Execution Result : (1 row(s) affected) (89 row(s) affected) (1 row(s) affected) Msg 262, Level 14, State 4, Line 25 SHOWPLAN permission denied in database 'tempdb'. 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.