Stored Procedure Metadata - SQL Server

SELECT * FROM sys.dm_exec_describe_first_result_set(N'[dbo].[MyStoredProcedure]', null, 0)