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 used to access the remote table:

• The provider must support bookmarks on the rowset opened through IOpenRowset on the table being updated or deleted.
• The provider must support the IRowsetLocate and IRowsetChange interfaces on the rowset opened through IOpenRowset on the table being updated or deleted.
• The IRowsetChange interface must support update (SetData) and delete (DeleteRows) methods.

Note The Microsoft® OLE DB Provider for SQL Server supports these interfaces only on a table that has a unique index. Because of this UPDATE or DELETE statements are permitted against a remote table in another Microsoft SQL Server™ only when the table has a unique index.