From: Sam on
Thank you all very much :-)
--
Thanks,

Sam


"Sam" wrote:

> Hi,
>
> I have a stored procedure with an OUTPUT parameter. When I execute the
> procedure in SQL Server Mgmt Studio, am I supposed to see the OUTPUT
> parameter's value?
>
> I'm troubleshooting an issue and at this point I'm not sure if it's the
> application code or the stored procedure. When I execute the stored
> procedure, it does what it's supposed to do i.e. insert a new record, but I
> do not see the value of the output param -- unlike when I return values
> through a SELECT statement. Is this normal or am I supposed to see the value
> returned by the output param?
> --
> Thanks,
>
> Sam