SET STATISTICS XML

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#