SET SHOWPLAN_TEXT

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_TEXT { ON | OFF }  [;]

Remarks

Argument values are ignored and do not change the default behavior.

Permissions

Requires membership in the public role.

See Also