Microsoft KB Archive/814581

= Error 7306 when updating or deleting data using a linked server in SQL Server 2000 =

Article ID: 814581

Article Last Modified on 5/11/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-





SYMPTOMS
When you use variables in the UPDATE or DELETE Transact-SQL statement to update or delete data in remote tables by using a linked server and the Other data source Provider name property is Microsoft OLE DB provider for SQL Server, you may receive the following error message:

Server: Msg 7306, Level 16, State 2, Line 4

Could not open table '&quot; &quot;.&quot;dbo&quot;.&quot; &quot;' 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.]



CAUSE
You may receive this error message if the UNIQUE index or PRIMARY KEY constraint does not exist on the remote table for Microsoft OLE DB providers to run an UPDATE or a DELETE Transact-SQL statement. You may also receive this error message if you have not selected the Allow InProcess option for the linked server. To select this option, in the Linked Server Properties dialog box, click Provider Options, and then click to select Allow InProcess.



WORKAROUND
To work around this problem, create a UNIQUE or PRIMARY KEY constraint on the remote table.



MORE INFORMATION
For more information, visit the following Microsoft Web sites:

Rules for Updating Results

Accessing External Data

Configuring Linked Servers

Configuring OLE DB Providers for Distributed Queries

Creating an Index

UPDATE and DELETE Requirements for OLE DB Providers

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

218995 BUG: Error &quot;Invalid object name&quot; on linked server table through OLEDB

Keywords: kberrmsg kbsysadmin kbprb KB814581

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.