1 Version 4.0 -- 1/15/89 sp_dropserver
______________________________________________________________________
NAME: sp_dropserver
FUNCTION:
Drop a server from the list of known servers.
SYNTAX:
sp_dropserver server [, droplogins]
EXAMPLES:
sp_dropserver GATEWAY
sp_dropserver Version 4.0 -- 1/15/89 2
______________________________________________________________________
This command drops the remote server GATEWAY.
PARAMETERS:
server - is the name of the server to be dropped.
droplogins - is a flag which indicates if any remote logins for
server should also be dropped. If you run sp_dropserver on a
server that has associated entries in the
master.dbo.sysremotelogins table, you will get an error mes-
sage that you need to drop the remote users before you can
drop the server. If you want to have all the remote logins
for a server dropped when you drop the server, supply the
value droplogins for the droplogins optional parameter. The
only legal value for droplogins is ``droplogins''.
COMMENTS:
o If you try to drop a server that has remote logins, the request
3 Version 4.0 -- 1/15/89 sp_dropserver
______________________________________________________________________
will be rejected unless you supply the droplogins parameter
with the value "droplogins".
MESSAGES:
The procedure was successful. The server named server is no
longer accessible through this server and it can no longer
access this server.
The server you have tried to drop is not a known server. All
known servers for a SQL Server are listed in the sysservers
table.
The server you want to drop has associated entries in the sys-
remotelogins table. You must either drop the remote logins
with the sp_dropremotelogin stored procedure or use the dro-
plogins parameter to the sp_dropserver stored procedure.
PERMISSIONS:
Execute permission to System Administrator.
sp_dropserver Version 4.0 -- 1/15/89 4
______________________________________________________________________
TABLES USED:
master.dbo.sysservers, master.dbo.sysremotelogins
SEE ALSO:
sp_dropremotelogin, sp_helpserver, sp_helpremotelogin