sp dropserver system procedure

GPTKB entity

Statements (15)
Predicate Object
gptkbp:instanceOf system stored procedure
gptkbp:cannotBeUsedIf server has associated remote or linked logins unless 'droplogins' is specified
gptkbp:documentation https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-dropserver-transact-sql
gptkbp:effect optionally removes associated logins if 'droplogins' is specified
removes server definition from sys.servers
gptkbp:hasSyntax sp_dropserver [ @server = ] 'server' [ , [ @droplogins = ] 'droplogins' ]
https://www.w3.org/2000/01/rdf-schema#label sp dropserver system procedure
gptkbp:introducedIn gptkb:SQL_Server_2000
gptkbp:parameter @droplogins
@server
gptkbp:purpose removes a server from the list of known remote and linked servers
gptkbp:requiresPermission ALTER ANY LINKED SERVER
gptkbp:usedIn gptkb:Microsoft_SQL_Server
gptkbp:bfsParent gptkb:Sybase_SQL_dialect
gptkbp:bfsLayer 7