Stored Procedures missing from interfered schema

[joshbooker]

What are the requirements for SQL Server sprocs to be seen when inferring? I only see tables and views. SQL Server 2008R2.

TIA,
Josh

[korchev]

Hi Josh,

Radzen uses sys.dm_exec_describe_first_result_set_for_object which requires SQL Server 2012.

Best regards,
Atanas

[davidmoss]

Hey Josh,

Some of my stored procedures were not showing up and I got around by adding an initial dummy call as explained here:

Using complex stored procedures with Radzen

Just passing on a workaround for those complex stored procedures that Radzen (specifically the Microsoft built in function ‘sys.dm exec describe first result set for object’) does not ‘Infer’ or allow you to add to your project. If the stored procedure is primarily for server side transaction processing and not to return dataset then a simple dummy select call will allow Radzen to ‘Infer’ the procedure and be added to your project for an ‘Invoke’. For example: ALTER PROCEDURE [dbo].[usp_GetDe…

Hope it helps,
David