Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

How to join a local table to a remote table by way of a linked server Expand / Collapse
Author
Message
Posted Thursday, March 01, 2012 8:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, March 15, 2014 9:30 AM
Points: 191, Visits: 512
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.
Post #1260192
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse