SQL Server:通过链接服务器访问链接服务器 [英] SQL Server : get access to linked server through linked server

问题描述

我有带链接服务器(例如Server1)的SQL Server 2008.通常我执行类似

I have SQL Server 2008 with linked server, for example Server1. Usually I execute queries like

SELECT * 
FROM [Server1,1444].[DBName].[dbo].[Table1]

但是这次我的目标表存储在不同的服务器上.该服务器与Server2一样在Server1上链接.因此，Server1的DBA给了我这个查询

But this time my target table is stored at different server. This server is linked on Server1 like Server2. So, DBA of Server1 gave me a this query

SELECT * 
FROM [Server2].[DB].[dbo].[My_table]

在Server1上，此查询可以正常运行，但是当我尝试在自己的服务器上运行该查询时，例如:

On Server1 this query runs without troubles, but when I try to run it on my own server like:

SELECT * 
FROM [Server1,1444].[Server2].[DB].[dbo].[My_table]

它向我显示一条错误消息，因为我正在尝试通过另一台链接服务器查询一台链接服务器.

it shows me an error message, because I'm trying to query one linked server through other linked server.

我的问题是:我如何执行对该Server2的查询?

My question is: how can I execute my query to that Server2?

推荐答案

所以我找到了解决方法

SELECT *  
FROM openquery([Server1,1444], 'SELECT* FROM [Server2].[DB].[dbo].[My_table]')

这篇关于SQL Server:通过链接服务器访问链接服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！