Jack Vamvas shows how you can delete data from a remote server using OPENQUERY:
How can I DELETE using OPENQUERY? Normally for a SELECT from OPENQUERY , I’ll do something like :
SELECT col1 ,col2 FROM OPENQUERY (MY_LINKED_SERVER,'SELECT col1,col2 FROM MY_LINKED_TABLE')Can a similar method be used but for DELETE?
Click through for the answer.