parser stack overflow".
Msg 7343, Level 16, State 4, Line 11
The OLE DB provider "MSDASQL" for linked server "ZOHOCRM" could not UPDATE table "[ZOHOCRM]...[Contacts]".
I have tried updating a few different fields on a contact record in a few different ways.
Code: Select all
UPDATE openquery(ZOHOCRM,'SELECT * FROM Contacts WHERE Id=''xxxx''') SET Salutation='Mr.'
UPDATE [ZOHOCRM]...[Contacts] set Salutation='Mr.' WHERE Id='xxxx'
Code: Select all
SELECT * FROM [ZOHOCRM]...[Contacts] WHERE Id='xxxx'
Seems like it might be related to this thread viewtopic.php?f=55&t=48622&p=200270&hil ... ow#p200270