An error occurred while deleting the table on the linked server.

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.