Solved

linked servers

Posted on 2003-10-22
5
1,576 Views
Last Modified: 2012-08-14
I get the following message while working with a cursor. This cursor is for a table which is on a linked server:

Remote tables are not updatable. Updatable keyset-driven cursors on remote tables require a transaction with the REPEATABLE_READ or SERIALIZABLE isolation level spanning the cursor.

This is not showed as an error or warning.
Its just a message.

Can someone tell me a little more abt. this message and the risks of using such cursors?

Thanks.
0
Comment
Question by:meers1974
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 9

Expert Comment

by:xenon_je
ID: 9600333
Can you please post the code you use to make the update?

Also you update non-key fields or the key fields?

Is the application doing what is supossed to do, or the message appears and beside the message, the updates are nott made? or they are made and they do not appear in the cursor (but are present in the database)?

in other words... try to go deeper, just beside the error message, and describe the behaviour of your app....

thx,
 xenon
0
 

Author Comment

by:meers1974
ID: 9600390
Following is the code:

DECLARE tmp_cursor CURSOR FOR
            SELECT VERSION_ID, VERSION_STAT FROM VERSION
            WHERE VERSION_STAT = 'Q'
            OR VERSION_STAT = 'R'

Open tmp_cursor

Fetch next from tmp_cursor into @version, @stat

While @@fetch_status = 0
Begin
      UPDATE VERSION
      SET VERSION_STAT = 'W', LAST_UPDT_DT = GETDATE()
      WHERE VERSION_ID = @version

      Fetch next from tmp_cursor into @version, @stat
End

The update happens perferctly. I am getting what I want.
But this message is also displayed:

Remote tables are not updatable. Updatable keyset-driven cursors on remote tables require a transaction with the REPEATABLE_READ or SERIALIZABLE isolation level spanning the cursor.

Does this mean any risk? I am getting the expected result anyway. So, I wanted to know the meaning of this message, to determine if I can ignore it or not.

Thanks.
0
 
LVL 9

Accepted Solution

by:
xenon_je earned 20 total points
ID: 9600956
In the code you posted I can't see any keyset cursor......

So not the code above produces the error....

The error you receive si the 16953, which has level 10 of severity...this means that is only a message...

 You can read the next link:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q269/6/94.asp&NoWebContent=1

But you have to go in yur code and find the certain code that generates this error message...

My advice: never go over an error message, even if its a warning one...Study it if you obtained it and only if you are very sure that you know many things about it move on...sometimes this 'jumping' over an warning message causes very big troubles in the future.....

The link I gave you suggests 2 choices to remedy the error...but obviously not on the code you posted...

good luck,
    xenon
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question