I have been experimenting with this stored procedure output parameter, and have gotten it to work, but only on the first call. All subsequent calls "fail" by returning no rows, but no error. The calling procedure _does_ close and deallocate the cursor. This is consistent in Query Analyzer, and also in the debugger. If I delete the Query Analyzer Sql worksheet and paste the query into a new one, it will work as many times as I want it to, but if I try to exec the same instance of the call more than once, only the first exec will return rows.

Has anyone run into this. I have not been able to find anything in a global search of MSDN and the web at large with numerous efforts.