Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
See Also
Concepts
OLE DB Provider Reference for Distributed Queries
Guidelines for Using Distributed Queries