INSERT Requirements for OLE DB Providers
SQL Server 2000
Transact-SQL INSERT 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 the IRowsetChange interface on the rowset opened through IOpenRowset on the table having data inserted into it.
- The IRowsetChange interface on the base table being inserted into must support the insert (InsertRow) method.