Home Dashboard Directory Help
Search

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


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 780521
Opened: 3/2/2013 11:20:54 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description


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
as
(
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.

Details
Sign in to post a comment.
Posted by Microsoft on 7/19/2013 at 5:33 PM
Hello,
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!
Sign in to post a workaround.