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 |
|
snufse
Constraint Violating Yak Guru
469 Posts |
 Posted - 2007-12-14 : 16:43:48
|
| On the same physical machine we have a server VGIWPW03-SQL3/SALES with database Sales and a server VGIWPW03_SQL/JOBS with data base Jobs. Is it possible to have a stored procedure located in Sales server that for example uses a sales table from Sales and a job table from Jobs as long as I have 2 connections open? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-14 : 16:47:58
|
| Yes this is possible. You can use linked servers or OPENQUERY to query remote objects.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Multiple Servers question