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';