Guys,
I know about linked servers, remote servers, however is there anyway appear to make remote objects and database appear like local objects in one sql server install as my third party applications can only access objects that appear local to one server.
Thanks.