@@FETCH_STATUS

11 Mar 2006 5:57 PM

Hussain Al-Mousawi

Hi there..

I have this problem: I run my stored proc alot of times for testing, but one
time it want work.

It just give me back this message: The command(s) completed successfully.

I checked the @@FETCH_STATUS and it became -1, why is that when it worked
before..

Can any body help me??
THX

11 Mar 2006 6:33 PM

SQL

@@FETCH_STATUS is for cursors, you want to use @@ERROR instead if it's 0
then there is no error

http://sqlservercode.blogspot.com/

Show quote

"Hussain Al-Mousawi" <hal_mous***@hotmail.com> wrote in message
news:uv6dVVTRGHA.2532@TK2MSFTNGP10.phx.gbl...
> Hi there..
>
> I have this problem: I run my stored proc alot of times for testing, but
> one time it want work.
>
> It just give me back this message: The command(s) completed successfully.
>
> I checked the @@FETCH_STATUS and it became -1, why is that when it worked
> before..
>
> Can any body help me??
> THX
>