For the sake of argument, let’s say my stored procedure has no input or output parameters and is just a SELECT statement:
CREATE PROCEDURE dbo.sp_GetBuildingList AS
SET NOCOUNT ON;
SELECT building, name
ORDER BY name
How do I set up the Connection Action to receive the ‘building’ and ‘name’ fields from the stored procedure? I tried adding Return Parameters (screenshot here: http://i.imgur.com/ZPHZE.png) but I get an error:
Agent SQL error
Procedure sp_GetBuildingList has no parameters and arguments were supplied.
How do I get those two rields back from my stored procedure?