Question on Linked server vs Local
Posted on 2007-07-24
I am trying to fix a problem I'm having trying to debug a stored proc on my sql server (I'm actually doing it on the server itself)
I get the dreaded
Server: Msg 11, Level 16, State 1, Line 0
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
After poking around I saw a suggestion to run
I get null after runnning it.
After more poking, I found a suggetion to do the following
Sp_Addserver 'WEB02', 'local'
When I run this I receive the following:
There are still remote logins for the server 'WEB02'.
I know web02 is setup as a linked server.
when I do a
select * from master..sysservers
The following is returned:
1 225 WEB02 SQL Server SQLOLEDB WEB02 NULL NULL 2006-11-30 17:20:47.583 NULL NULL NULL NULL 0 0 WEB02 1 1 0 0 0 0 1 1 0 0 0 0 NULL
Could someone explain to me exactly what Sp_Addserver 'WEB02', 'local' does?