sp_describe_first_result_set and system_type_name NULL - by Andrea_Benedetti

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.


4
0
Sign in
to vote
ID 765998 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 10/3/2012 3:58:44 PM
Access Restriction Public

Description

If you exec this script:

EXEC sp_describe_first_result_set @tsql = N'exec [AdventureWorks2012].[dbo].[uspGetEmployeeManagers] 1';

You can find NULL on [system_type_name] when system_type_id is not unique in sys.types.

Maybe, internally, the join must be:
sys.columns.system_type_id = sys.types.user_type_id
Sign in to post a comment.
Posted by Microsoft on 1/4/2013 at 12:58 PM
Hello Andrea,
We have now fixed the issue for the next major version of SQL Server. We may port it to a future SQL Server 2012 cumulative update if there are many occurrences of this issue.

--
Umachandar, SQL Programmability Team
Posted by Microsoft on 10/9/2012 at 12:38 PM
Hello Andrea,
Thanks for reporting this issue. We will take a look at it & get back to you.

--
Umachandar, SQL Programmability Team