Master..sysservers

Hey all,
My question is: Is it possible for the master..sysservers
table to be empty? I am running a job which requires
connection to all my other sql servers but i am unable to
because : Server: Msg 7202, Level 11, State 2, Line 1
Could not find server 'XXXX' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
This job usto work perfectly. This server is a production
server and rebooting it might not be the best option. Any
one got any ideas?Claudy,
I don't believe the table can be empty. Though I can not find a document
about it, the table should at least contain the local server with id = 0. I
use this table for some of my tasks and have always been assuming that the
local server is there, and it has been working.
As of your problem, the error message does not say that the table is empty.
It says it could not find the remote server. If the access of the remote
server is called for by an application, you may have the linked server
removed. If the application is cycling through the table for linked
servers, the linked server may not be running or the network is not
functioning. There might be other problems, so be sure checking beyond the
sysserver table.
Quentin
"Claudy" <alphaseusa@.hotmail.com> wrote in message
news:068a01c396e8$dc2de440$a501280a@.phx.gbl...
> Hey all,
> My question is: Is it possible for the master..sysservers
> table to be empty? I am running a job which requires
> connection to all my other sql servers but i am unable to
> because : Server: Msg 7202, Level 11, State 2, Line 1
> Could not find server 'XXXX' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
> This job usto work perfectly. This server is a production
> server and rebooting it might not be the best option. Any
> one got any ideas?