A stored procedure that I would like to add to LLBLGen Pro does not show in the New Stored Procedures dialogue box when I click Add New Action Stored Procedure Call. I tried Add New Retrieval Stored Procedure Call just in case, but it does not show up there either.
It is a complex stored procedure for sending an email message. There are no result sets, apart from the possibility of an error message output with SQL's PRINT statement: I'm not sure if that counts as a result set or not. Has that got something to do with the problem? I would be quite happy to not capture the error message if there is one: checking the stored procedure's return value for success or failure would be good enough. I could stop the stored procedure from PRINTing error messages, or use SELECT instead of a PRINT, if either of those would solve the problem.
The only other thing I can think of that might be unusual is that the stored procedure calls a hierarchy of other stored procedures, including one that PRINTs the error messages.