Dropping Remote Servers

You drop a remote server with the sp_dropserver system procedure, which deletes the entry for that server from the sysservers table. When you drop a remote server, a user can no longer access its information through the local server.

    To drop a remote server

• Type:

  sp_dropserver server_name [, droplogins]

  where

  server_name

  Is the server to be dropped.

  droplogins

  Drops all remote logins for the remote server that is being dropped. You must either explicitly drop the remote logins before you drop the remote server, or you must use this option. For more information about remote logins, see Managing Remote Users, later in this chapter.

  The droplogins option is not needed to drop the local server's entry, because the local server does not have remote login information associated with it.

For example, to drop EXPENSES and its remote logins, type:

sp_dropserver expenses, droplogins

For more information about sp_dropserver, see the Microsoft SQL Server Transact-SQL Reference.