I have a stored procedure that is returning a record (this is all that is in the SP):

SET NOCOUNT ON;
EXEC('Select * from  ' + @TableName + ' FOR XML AUTO, XMLSCHEMA')

The SP isshowing up in LLBL as an Action stored procedure and thus the generated code only expects an int in return.

How can I make this a Retrieval SP?

I tried setting NOCOUNT OFF but that did not work.

Thanks

Please try this: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=14888

That was perfect.

Thankyou!