My gut feeling is that you can get this done by tweaking linked server only. I will try to re-produce this in my environment today.

Thanks

Chandan