Inconsitent results from sys.dm_exec_describe_first_result_set_for_object when objectID not valid - by Dave_Ballantyne

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<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 780521 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 3/2/2013 11:20:54 AM
Access Restriction Public


sys.dm_exec_describe_first_result_set_for_object returns inconsistent results when the objectid is not valid.

Select * From sys.dm_exec_describe_first_result_set_for_object(object_id('NoObject'),1);

Returns a single row with a column stating and error message "The object id '0' passed to sys.dm_exec_describe_first_result_set_for_object was invalid."

However :

with cteProcs
   Select object_id('uspGetBillOfMaterials') as ObjectId
   union all
   Select object_id('uspGetBillOfMaterialsNotFound') 

select * from cteprocs
         cross apply sys.dm_exec_describe_first_result_set_for_object(objectid,1);

Returns the same data repeated ( though with nullified objectids) for both executions.
Sign in to post a comment.
Posted by Microsoft on 7/19/2013 at 5:33 PM
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product.
Posted by Dave_Ballantyne on 3/2/2013 at 11:22 AM
Formatting of the above looks ok when edited!