Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp How to join a local table to a remote table by way of a linked server RE: How to join a local table to a remote table by way of a linked server

  • March 1, 2012 at 8:25 am

    #1453668

    Working in an environment with multiple security bands, multiple networks and load balanced servers there's no way linked servers are possible, practical, or desired.

    SSIS or some other tool that allows heterogeneous data connects is a good solution to dealing with these situations.

    In a smaller shop linked servers might be the preferred solution but I really haven't seen it done in any of my work environments since we brought in 2005.