开发者

SQL Servers: Linked-servers without linking servers?

Both my local (and remote) SQL SERVER 2005 administrators claim that "allowing linked-servers is a security issue" and forbid their use here. (Huh?)

Anyway, is there a way to do something similar WITHOUT linked-servers?

SELECT *
FROM LOCAL_SERVER.MyDatabase开发者_Go百科.dbo.MyTable AS t1
INNER JOIN REMOTE_SERVER.MyDatabase.dbo.MyTable AS t2
ON t1.MyField = t2.MyField 


You could use OPENROWSET, which'll require the connection info, username & password...

While I understand that the administrator believes that having an always-on connection to their data is risky, that's why you lock down the account. OPENROWSET means including the connection info in plain text.


yes you can use OPENDATASOURCE but ad-hoc queries have to be enabled

Opendatasource: Provides ad hoc connection information as part of a four-part object name without using a linked server name.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜