将两个sql服务器彼此连接 [英] connect two sql servers to each other

问题描述

大家好，

我要问我在局域网中有两台计算机，并且都安装了sql server 2008.我想从1到第二台计算机访问数据库.就像第二台计算机具有以下数据库一样
1.DB
2.MyDatabase
我想使用sql server 2008从第一台计算机访问这两个数据库.两个都安装了Windows XP.
请帮助我连接两个sql服务器以共享数据库.

谢谢
请帮助

Hello all,

I wana ask that i have two computers in a LAN and both have sql server 2008 installed. I want to access database from 1 to second computer. Like if second computer has following databases
1.DB
2.MyDatabase
I want to access both of these databases from my first computer using sql server 2008. Both have windows xp installed.
plz help me to connect both sql servers to share database.

Thanks
Plz help

推荐答案

在计算机1上，创建了到计算机2的链接服务器

http://msdn.microsoft.com/en-us/library/ms188279.aspx [ ^ ]

然后，您可以使用启动TSQL对服务器发出4个部分命名查询，例如

On Machine 1, created a linked server to Machine 2

http://msdn.microsoft.com/en-us/library/ms188279.aspx[^]

You can then issue 4 part naming queries against the server using start TSQL, e.g.

Select Field1, Field2
From
    MyLinkedServerName.dbo.DatabaseName.TableName
Where
    IdField = 1

这篇关于将两个sql服务器彼此连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！