Unknown Error

• tygun

  SSCrazy

  Points: 2381

  More actions

  June 19, 2003 at 1:41 pm

  #101531

  Does anyone know what this error code means?

  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.

• mworku

  Ten Centuries

  Points: 1311

  More actions

  June 19, 2003 at 3:02 pm

  #462288

  Ref. article

  http://msdn.microsoft.com/library/default.asp?url=/library/en-s/acdata/ac_8_qd_12_3164.asp

  you can also use the openrowset function to update remote tables

  Update

  OpenRowSet('SQLOLEDB','SERVER';'UserName';'Password',

  'Select au_id, au_fname

  From Pubs..Authors')

  Set au_fname = 'Test'

  Where au_id = '172-32-1176'

  MW

  
  MW