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 |
|
MutantsForNukes
Starting Member
2 Posts |
 Posted - 2004-06-29 : 13:36:08
|
| I'm interested in writing a query that pulls data from 2 different databases that are located on different servers. I'm familiar with the <database>..<table> syntax, but that only seems to work for databases that are on the same server. Does anyone know if this can be done?If not through a query, can a dba create views within a database that can look to other server databases? Any other options? Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-29 : 13:37:55
|
| You will need to setup a linked server. Then you reference the other database on the remote server with the 4 part naming convention using the linked server name.Look up linked server in SQL Server Books Online for more information.Tara |
 |
|
|
MutantsForNukes
Starting Member
2 Posts |
Posted - 2004-06-29 : 14:05:39
|
| Outstanding! Thanks. |
|
|
|
|
|
|
access multiple databases across servers w/ query