DF015: The SET FMTONLY statement is used.

CREATE OR ALTER PROCEDURE dbo.SelectUserData
AS BEGIN
SET NOCOUNT ON;
SELECT * FROM dbo.UserData ud
END;
GO
 
SET FMTONLY ;
GO
EXEC dbo.SelectUserData
GO
SET FMTONLY OFF;
GO
 
SET FMTONLY ON;
GO
SELECT * FROM sys.columns
GO
SET FMTONLY OFF;
GO

EXEC sp_describe_first_result_set @tsql = N'exec dbo.SelectUserData'
GO
EXEC sp_describe_first_result_set @tsql = N'select * from sys.columns'
GO