STATISTICS XML always report the same StatementSetOptions - by Erland Sommarskog

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 335971 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 3/30/2008 3:32:13 AM
Access Restriction Public

Description

In the  XML returned when SET STATISTICS XML ON, there is a tag
StatementSetOptions, but the contents seems to always be the same,
no matter the actual settings. Am I missing something?
Sign in to post a comment.
Posted by Microsoft on 4/2/2008 at 10:28 AM
Dear Erland,

Thank you for reporting this issue to us. We are working on fixing this issue. For now, you could try using sys.dm_exec_plan_attributes (it exposes set_options attribute) as a workaround.

Regards,
Leo Huang
SQL Server Relational Engine Team