SET STATISTICS XML

Causes engine to execute Transact-SQL statements and generate detailed information about how the statements were executed in the form of a well-defined XML document.

Syntax

SET STATISTICS XML  { ON | OFF }  [;]

Remarks

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

Permissions

Requires membership in the public role.

See Also