combining data on different sevvers

From: "Charles MacLean" <charlesmaclean@xxxxxxxxxxxxx>
Date: Thu, 10 Aug 2006 13:42:15 GMT

I need to combine data from two different tables on two MS SQL servers
running on the same LAN into a single SELECT or VIEW. Is this possible and
what would the syntax look like?

Thanks,
Charles
MTS, Inc.

.

Follow-Ups:
- Re: combining data on different sevvers
  - From: Arnie Rowland

Prev by Date: Conncting to SQL Server 2005 database
Next by Date: Re: SQLServer Connection Problems...
Previous by thread: Conncting to SQL Server 2005 database
Next by thread: Re: combining data on different sevvers
Index(es):
- Date
- Thread

Relevant Pages

Re: what about: instances of sql
... with web and sql servers ... for the lan, ... to connect directly to the sql:1433 on dmz ... In any case, if you have multiple instances on a production> box, you'll want to set an upper memory limit for each. ...
(microsoft.public.sqlserver.server)
Connecting to different named instances on MS SQL 2005 from Linux
... I'm connecting to many a few different MS SQL servers. ... When connecting using the following syntax, ... server and its assigned port. ...
(perl.dbi.users)
Re: Get list of running SQL servers in a LAN?
... I want to get a list of running SQL servers in a LAN in code. ... It lists sql servers only on W2k, ...
(borland.public.delphi.database.ado)
Re: Server.Transfer Vs. Response.Redirect... to... \209.11.22.33MyDir
... >If the target IP is on your LAN you can access that server's file-system ... >using that syntax. ... Server.Transfer and response.redirect expect a valid URL ...
(microsoft.public.scripting.vbscript)
Re: Server.Transfer Vs. Response.Redirect... to... \209.11.22.33MyDir
... >If the target IP is on your LAN you can access that server's file-system ... >using that syntax. ... Server.Transfer and response.redirect expect a valid URL ...
(microsoft.public.inetserver.asp.general)