Menu
Home / CSE MCQs / SQL Server MCQs :: Discussion

Discussion :: SQL Server MCQs

  1. To produce execution plan output by using most Showplan Transact-SQL SET options, users must have
    2. A.
    SHOW SHOWPLAN
    B.
    SHOW PLAN
    C.
    SHOWPLAN
    D.
    None of the mentioned

    View Answer

    Workspace

    View Answer

    Answer : Option C

    Explanation :

    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.

Write your comments here:

Be The First To Comment