Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
 Posted - 2004-09-02 : 01:15:06
|
| Hi,I am not able to update a linked table.Its giving the following error:Server: Msg 7306, Level 16, State 2, Line 1Could not open table '<Table Name>' 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.] Here is the update statementupdate linkedserver.dbname.dbo.tbnameset date_changed = getdate()where shopper_id='122'Thanks Shallu |
|
|
|
|
|
Error Updating Linked Table