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
|