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.

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


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 Umachandar [MSFT] 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 Umachandar [MSFT] 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