I am updating a view within a stored procedure , this view is on a different database server than the stored proc
I am using the LINKEDSERVER.database.dbo.VIEW syntax to update the view within the stored procedure
I get this error
Could not create an acceptable cursor, OLE DB provider SQLNCLI10 for linked server XYZ returned message. Multi step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done.