Export (0) Print
Expand All

UPDATE and DELETE Requirements for OLE DB Providers

Transact-SQL UPDATE and DELETE statements can reference remote tables only if the following conditions are met by the OLE DB provider that is used to access the remote table:

  • The provider must support bookmarks on the rowset opened through IOpenRowset on the table that is being updated or deleted.
  • The provider must support the IRowsetLocate and IRowsetChange interfaces on the rowset opened through IOpenRowset on the table that is being updated or deleted.
  • The IRowsetChange interface must support update (SetData) and delete (DeleteRows) methods.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft