Hi Hugh,

I ran out of time trying to solve the problem and ended up setting up a few DTS packages to import/update SQL tables which I created as a mirror image of the Sage tables and then my application uses these tables so there's no need to have all the linked server stuff going on. These DTS packages run every 15 minutes so it's not exactly live and wouldn't suit every application but for what I needed it has worked fine.