accessing database on second sql server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ted185 - 31 Jul 2008 18:49 GMT

Is there a way to set up a sql server so that a querry run against database 1
on SQL server1 can pull data from databse 2 on sql server 2 as if database 2
existed on sql server 1?

I though I had seen a feature to link a sql server to see the databases
stored on another sql server but I can not find the info again

Thank You

ted

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 31 Jul 2008 18:51 GMT

Yes, have a look at "linked servers" in Books Online. With a linked server,
you can say

SELECT col_list FROM linked_server_name.database_name.dbo.table_name;

On 7/31/08 1:49 PM, in article
3635C072-C8A4-4A99-8A42-83FA7B5BE40B@microsoft.com, "ted185"

> Is there a way to set up a sql server so that a querry run against database 1
> on SQL server1 can pull data from databse 2 on sql server 2 as if database 2
[quoted text clipped - 6 lines]
>
> ted

Reply to this Message

Jeffrey Williams - 31 Jul 2008 18:53 GMT

> Is there a way to set up a sql server so that a querry run against database 1
> on SQL server1 can pull data from databse 2 on sql server 2 as if database 2
[quoted text clipped - 6 lines]
>
> ted

Yes, it is called linked servers. You can find more information in BOL.

Reply to this Message