Monday, March 12, 2012

Msg 16958: Could not complete cursor operation

Got this error:
Msg 16958:
"Could not complete cursor operation because the set
options have changed since the cursor was declared."
The only thing I did was change the Recovery model to
SIMPLE from FULL. Apparently a cursor was open prior to
the change?
Knowledge Base turned up empty.
Thanks,
DanWell -- I didn't find much about this error even when I "googled" it.
Some people have reported that re-starting SQL Server fixes this.
In my case, it did NOT.
However, I was able to get this to work again by applying the following
setting:
SET ARITHABORT ON
"Dan Carollo" <d.carollo@.verizon.net> wrote in message
news:088401c3db1f$b0c0a470$a101280a@.phx.gbl...
> Got this error:
> Msg 16958:
> "Could not complete cursor operation because the set
> options have changed since the cursor was declared."
>
> The only thing I did was change the Recovery model to
> SIMPLE from FULL. Apparently a cursor was open prior to
> the change?
> Knowledge Base turned up empty.
> Thanks,
> Dan

No comments:

Post a Comment