stored procedure execution

15 Jul 2006 7:01 AM

nithya

We have upgraded our operating system of database server to win 2003 standard
edition. We could install the sql server-2000 properly. All workstations are
still win-NT and established the connectivity also. But when we tried to
execute the stored procedures it shows error as follow.

â€œMsg 16957, Sev 16: FOR UPDATE cannot be specified on a READ ONLY cursor.
[SQLSTATE 42000]â€

Kindly give a solution for the above problem
Reply to
Nithya_kris***@rediffmail.com

15 Jul 2006 7:10 AM

Adi

Most chances are that it has nothing to do with the upgrade to win 2003
and that it has to do with the procedure's code. Could you post the
procedure's code?

Adi

nithya wrote:
Show quote

> We have upgraded our operating system of database server to win 2003 standard
> edition. We could install the sql server-2000 properly. All workstations are
> still win-NT and established the connectivity also. But when we tried to
> execute the stored procedures it shows error as follow.
>
> "Msg 16957, Sev 16: FOR UPDATE cannot be specified on a READ ONLY cursor.
> [SQLSTATE 42000]"
>
> Kindly give a solution for the above problem
> Reply to
> Nithya_kris***@rediffmail.com

15 Jul 2006 7:37 AM

Omnibuzz

The issue might be with the implicit cursor conversions. If the table doesn't
have unique index, then cursors can be converted to read only or if the db is
readonly or if its an access permission problem.

There are lots of discussions on this.. search for "cursor readonly update"
in google groups.

Hope this helps.

--
-Omnibuzz (The SQL GC)

http://omnibuzz-sql.blogspot.com/

15 Jul 2006 4:11 PM

Arnie Rowland

Without seeing the stored procedure code, we are just guessing.

--
Arnie Rowland
"To be successful, your heart must accompany your knowledge."

Show quote

"nithya" <nit***@discussions.microsoft.com> wrote in message
news:B1D68E0E-2393-480B-92E0-FC9E5B98BD1B@microsoft.com...
> We have upgraded our operating system of database server to win 2003
> standard
> edition. We could install the sql server-2000 properly. All workstations
> are
> still win-NT and established the connectivity also. But when we tried to
> execute the stored procedures it shows error as follow.
>
> "Msg 16957, Sev 16: FOR UPDATE cannot be specified on a READ ONLY cursor.
> [SQLSTATE 42000]"
>
> Kindly give a solution for the above problem
> Reply to
> Nithya_kris***@rediffmail.com
>