SQL Linked Servers - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

SQL Linked Servers

SQL Linked Servers# Database - 数据库

a*t2005-09-30 07:09

1 楼

I need to run a join query on tables on different SQL Servers. I've look it up
and find out I need to use sp_addlinkedsrvlogin. However, when I run it (with
correct inputs) I get,
"Server: Msg 15015, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 40
The server 'remoteServerName' does not exist. Use sp_helpserver to show
available servers."
When I run sp_helpserver it only shows the current server I am connected to.
The remote server has already been registered in SQL enterprise manager,

a*t2005-09-30 07:09

2 楼

solved by using enterprise manager linked server graphical interface :]

up
with
40
I

【在 a*******t 的大作中提到】

: I need to run a join query on tables on different SQL Servers. I've look it up
: and find out I need to use sp_addlinkedsrvlogin. However, when I run it (with
: correct inputs) I get,
: "Server: Msg 15015, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 40
: The server 'remoteServerName' does not exist. Use sp_helpserver to show
: available servers."
: When I run sp_helpserver it only shows the current server I am connected to.
: The remote server has already been registered in SQL enterprise manager,