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