[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

linked servers

Posted on 2003-10-22
5
Medium Priority
?
1,583 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 80 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

656 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