I have a few (SQL server) stored procedures that are triggering some system warnings as well as some of my own warnings (serverity 10). I'd like to return those warnings to the client (VFP through ODBC). There is the "Dispwarning" setting that I set to TRUE, but it looks like the SQL will report the warnings only if at lest one error (severity 16 ot higher) occurred.

Is there any way I can return the all warnings even if no error occured?

Thank you.