Sail E0 Webinar
Question
To produce execution plan output by using most Showplan Transact-SQL SET options, users must have
Options:
A .  SHOW SHOWPLAN
B .  SHOW PLAN
C .  SHOWPLAN
D .  None of the mentioned
Answer: Option C


The SHOWPLAN permission on the databases that contain objects referred to in the Transact-SQL statement, such as views, stored procedures, or user-defined functions.



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers