Home Dashboard Directory Help

Show Actual Query Plan causes error by Vendoran


 as Fixed Help for as Fixed

Sign in
to vote
Type: Bug
ID: 785151
Opened: 4/19/2013 11:27:44 AM
Access Restriction: Public
User(s) can reproduce this bug


When I run the following query in SQL 2008 R2 and in SQL 2012 with Show Actual Query Plan turned off, the results are as expected. However when run in SQL 2012 with Show Actual Query Plan turned on - an error is returned with a result of NULL

More info at http://stackoverflow.com/questions/16109393/show-actual-query-plan-causes-error
Sign in to post a comment.
Posted by Microsoft on 1/5/2014 at 6:11 PM
Thanks for submitting this feedback. This issue has been resolved and a fix will be available in an upcoming servicing release for SQL Server 2012. We will update you when the fix has been shipped. Thanks again for your continued support in SQL Server.
Posted by Microsoft on 10/8/2013 at 10:32 AM
For INSERT EXEC, statistics XML used to be unavailable with earlier version of SQL server. As a part of better usability, we added such support for SQL 2012, but missed a couple of cases including your scenario. This issue will be fixed in the next service pack.
Thank you very much for your feedback, and making SQL server better.
Posted by Microsoft on 4/29/2013 at 4:46 PM
Hello Vendoran. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.