So other ideas on how to view sp values from an app:
1. If your stored procedure isn't currently returning a select statement, one thing you could do is build a SELECT statement inside the stored procedure, made up of variables that you want to view the values of.
So the last line of the sp would be something like:
Select @firstVar as 'FirstVariable',
@2ndVar as 'SecondVariable'
These variables could have been created anywhere inside the stored procedure. In the app you could create a recordset and view the values from there.
Hopefully that's helpful.
2. Stored Procedures can also return an integer value using the RETURN statement, which can be used in addition to a SELECT statement being returned. (See Sql Books Online under return)
3. Then there's OUTPUT variables; let me know if you need help w/ the syntax of those 'cause it can be tricky (as far as reading them from the app).
Cheers,
Ray