In order to do this, you would have to do an analysis of the actual SP
code. There really isn't a good way to do this without running the proc
itself.
Basically, a stored procedure can do both, set the return values through
parameters/the return value, and return a result set.
You can query the sysobjects table to get the id of the stored
procedure, then you should be able to query the syscolumns table (using the
id of the SP) to determine what parameters the stored proc has (filtering on
the id of the object). From there, you can tell if they are output values.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
<wa********@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Using ADO.NET Or regular queries on SQL Server, is there a good way of
determining if a Stored Proc will be returning a result set or if it is
a non-query that does all I/O through parameters?
Thanks.