Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-27 : 10:43:35
|
Paul writes "I know that in SQL7.0 or SQL 2000, one can have multiple sites
(SQL Servers) access with a single query.
Example:
Select A.EmpoyeeID, B.OrderID, B.Discount from
SQLServer1.Northwind.dbo.Employee as A,
SQLServer2.Northwind2.dbo.Order as B
where A.EmpoyeeID = B.OrderID
And SQLServer1 and SQLServer2 is added through
sp_addlinkedserver.
My question is if these 2 Servers are far away (not in local network), how can I access it? Should I go through http (like in web but how), or should I have to setup a Vertual Private
Network (VPN) which connect the 2 PCs and do the query?
Thanks?" |
|
|
|
|
|
Distributed Queries (multiple remote sites)