SET SHOWPLAN_ALL#
Causes engine not to execute Transact-SQL statements. Instead, a detailed information about how the statements executed is returned that provides estimates of the resource requirements for the statements.
Syntax#
SET SHOWPLAN_ALL { ON | OFF } [;]
Remarks#
Argument values are ignored and do not change the default behavior.
Permissions#
Requires membership in the public role.