sp_dropserver

Removes a connection from the list of known connections on the instance of Lyftron.

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 Lyftron.

    sp_dropserver 'myoracleconnection', 'droplogins';

See Also