Solved

linked servers

Posted on 2003-10-22
5
1,554 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
  • 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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…

825 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