a*******t
发帖数: 891 | 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*******t
发帖数: 891 | 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,
|
|
