June 19, 2002 at 6:25 am
I have a SP (SQL 2000) that executes an update against a view, the view is simple "select *" from a SQL 7 table using a linkserver to connect. I can issue selects and simple updates against the view, but run into problems when updating based on a join to a temp table.
Error text -
Server: Msg 7306, Level 16, State 2, Procedure prc_sa_s_iadb_extract, Line 523
Could not open table '"iadb"."dbo"."tblTransactions"' 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.]
June 19, 2002 at 5:07 pm
Take a look here http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q270119
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 24, 2002 at 3:36 am
Create a unique index on the table. This should solve your problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply