sp dropserver system procedure
GPTKB entity
Statements (15)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb: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' ]
|
| 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 |
8
|
| https://www.w3.org/2000/01/rdf-schema#label |
sp dropserver system procedure
|