Jeffrey,

Thanks for your posting. I think the linked servers are set up, because a similar query does successfully copy the rows from ODS to ODSARCH without trouble. I...

Thanks Jeffrey and GSquared.

Jeffrey, your suggestions do indeed eliminate the sql syntax errors. However I could not find any substantiation for your suggestion on the delete clause when looking...