One of my friends asked me one question when he tries to check the execution plan the he received an error as follows:-
Msg 262, Level 14, State 4, Line 1 SHOWPLAN permission denied in database ‘ABCDEMO’.
It is very common now a day and this is impossible to provide admin rights to all the developers, but It was very easy to fix this issue. We can fix this issue to give the right to login.
USE ABCDEMO GO GRANT SHOWPLAN TO testlogin GO
After execution of above query you are able to see the execution plan:-
