1 Version 4.0 -- 1/15/89 sp_addserver
______________________________________________________________________
NAME: sp_addserver
FUNCTION:
Define a remote server, or define the name of the local server.
SYNTAX:
sp_addserver server [, local]
EXAMPLES:
sp_addserver GATEWAY
sp_addserver Version 4.0 -- 1/15/89 2
______________________________________________________________________
This command creates an entry for a remote server named GATEWAY
in the local master.dbo.sysservers table.
PARAMETERS:
server - is the name of the new remote server. It is added into
the master.dbo.sysservers table of the master database.
local - is an optional parameter that identifies the server
being added as the local server. This sets the value of the
global variable @@servername and prints out the server name
on the console at server boot time. The only legal value for
the local parameter is ``local''.
COMMENTS:
o The sysservers table is used to identify the name of the local
server and its options and to identify any remote servers that
the local server may want to communicate with.
3 Version 4.0 -- 1/15/89 sp_addserver
______________________________________________________________________
o To execute a remote procedure call on a remote server the
remote server must have been added to the sysservers table.
o Server names are unique.
o Server options may be set or cleared using the stored procedure
sp_serveroption.
o The local definition only takes place after a reboot.
MESSAGES:
The procedure was successful. There is now a server named server
known to the local SQL Server.
Server names are unique and you have tried to add a new server
using the name of an existing server.
Although there may be many remote servers, there can be only one
local server. When you run the sp_addserver procedure with
the local option, you are defining the name of the local
sp_addserver Version 4.0 -- 1/15/89 4
______________________________________________________________________
server. If it already exists, the request is rejected.
PERMISSIONS:
Execute permission to Database Owner and System Administrator.
TABLES USED:
master.dbo.sysservers
SEE ALSO:
sp_dropserver, sp_serveroption, sp_helpserver,
sp_helpremotelogin, sp_addremotelogin, sp_dropremotelogin