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.

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


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.

Leo Huang
SQL Server Relational Engine Team