This is a solution for the errors that arise when using the LINK server between MSSQL database server. If you use the LINK server name it Server A and Server B, then created a procedure in Server A, where the procedure is to read the data available in the link server B.
At the time the procedure is run on server A and will update the server B (Insert / Update / Delete) but it appears the following error:
At the time the procedure is run on server A and will update the server B (Insert / Update / Delete) but it appears the following error:
Server: Msg 16955, Level 16, State 2, Line 1
Could not create an acceptable cursor.
OLE DB provider "SQLNCLI" for linked server "xx.xx.xx.xx" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
That happens because the server used table B there is no Unique Index or Primary Key. So the solution can be given is:
- Tables are used in servers LINK B add Primary Key or Unique Index (Non-clustered).
If you've added, then the error will be resolved.
- Tables are used in servers LINK B add Primary Key or Unique Index (Non-clustered).
If you've added, then the error will be resolved.
