The linked server does not set a primary key. An error occurred while executing the following statement:
Delete from [OA \ srv1]. fpmis. DBO. s64z1_where BH not in (select post_code from post)
Returned results:
Server: Message 7306, level 16, status 2, Row 1
Failed to open the table '"fpmis". "DBO". "s64z1_"' (from the ole db Provider 'sqloledb '). The provider does not support row lookup locations. The provider identifies a conflict with other attributes or requirements.
[OLE/DB Provider returned message: an error occurs when you perform multiple ole db operations. If possible, check the status value of each ole db. No work is completed.]
Ole db Error Tracking [OLE/DB Provider 'sqloledb' iopenrowset: OpenRowSet returned 0x80040e21: [propid = dbprop_bookmarks value = true status = dbpropstatus_conflicting], [propid = dbprop_commandtimeout value = 600 status = dbpropstatus_ OK], [propid = unknown propertyid value = true status = dbpropstatus_ OK], [propid = dbprop_irowsetlocate value = true status = Success], [propid = dbprop_irowsetchange value = true...
Then I set a primary key, and it would be okay. The specific reason is not further explored.