Linked server

• joemai

  Hall of Fame

  Points: 3496

  More actions

  August 18, 2005 at 12:54 am

  #363466

  Please help!

  I tried to delete data from 5 tables from  linked server.  I got 4 successfully, and only one table gave me this error:

  'Could not open table '"sweet"."dbo"."visit_detail"' from OLE DB provider 'SQLOLEDB'.  The provider could not support a row lookup position. The provider indicates that conflicts occurred with other properties or requirements.

  [OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]

  OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IOpenRowset:penRowset returned 0x80040e21:  [PROPID=DBPROP_BOOKMARKS VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_COMMANDTIMEOUT VALUE=600 STATUS=DBPROPSTATUS_OK], [PROPID=Unknown PropertyID VALUE=True STATUS=DBPROPSTATUS_OK], [PROPID=DBPROP_IRowsetLocate VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_IRowsetChange VA...

  I couldn't find out why I got this error. This table had exactly same structure like other 4.

  My query is:

  delete [122.24.2.5].sweet.dbo.visit_detail

  from 122.24.2.5].sweet.dbo.visit_detail a

  inner join temp_stats_daily b

  on a.remote_host = b.remote_host

  Thanks so much for any ideas.

  Minh Vu

• peterhe

  SSChampion

  Points: 11469

  More actions

  August 18, 2005 at 7:35 am

  #583010

  Are all the 5 tables on the same linked server? check this http://support.microsoft.com/kb/269495/EN-US/ maybe helpful.

   

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  August 19, 2005 at 5:03 am

  #583465

  Could the problem be:

  delete [122.24.2.5].sweet.dbo.visit_detail

  from [122.24.2.5].sweet.dbo.visit_detail a

  inner join temp_stats_daily b

  on a.remote_host = b.remote_host

  Andy