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. 5. Point out the wrong statement :
A. SET SHOWPLAN_XML can be specified inside a stored procedure
B. SET SHOWPLAN_XML returns information as a set of XML documents
C. SET SHOWPLAN_XML is intended to return output as nvarchar(max) for applications such as the sqlcmd utility
D. All of the mentioned
Answer:A
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. 5. Point out the wrong statement :
A. SET SHOWPLAN_XML can be specified inside a stored procedure B. SET SHOWPLAN_XML returns information as a set of XML documents C. SET SHOWPLAN_XML is intended to return output as nvarchar(max) for applications such as the sqlcmd utility D. All of the mentioned
Explanation:It must be the only statement in a batch. 6. The document containing the XML schema for the XML output by SET STATISTICS XML is located at :