sp_dropserver#
Removes a connection from the list of known connections on the instance of Querona.
Syntax#
sp_dropserver [ @server = ] 'server'
[ , [ @droplogins = ] { 'droplogins' | NULL} ]
Arguments#
[ @server = ] ‘server’
Is the connection name to be removed. server is sysname, with no default. server must exist.
[ @droplogins = ] ‘droplogins’ | NULL
Indicates that related logins must also be removed if droplogins is specified. @droplogins is char(10), with a default of NULL.
Remarks#
If you run sp_dropserver on a server that has associated remote and linked server login entries, an error message is returned. To remove all logins when you remove the connection, use the droplogins argument.
Permissions#
Requires ALTER ANY LINKED SERVER permission.
Example#
The following example removes the connection myoracleconnection and all associated logins from the current instance of Querona.
sp_dropserver 'myoracleconnection', 'droplogins';