When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery ...

I am trying obtain some data from a Cache database into a Mysql database using Cache's SQL Gateway.Getting the data out of Cache is easy, but I am not sure about the easiest way to get it into ...