Displaying Information About Remote Servers

You can use sp_helpserver to determine which servers are set as remote servers of the local server. You can use sp_helpserver without an argument to provide information for all servers listed in sysservers. You can specify a server name to return information for that server only.

The sp_helpserver system procedure returns the server name, server network name, server status, and server ID from the sysservers table. A server status of rpc indicates a remote server.

    To display information about servers

• Type:

  sp_helpserver [server_name]

  where

  server_name

  Is the name of the server.

For example, to display information about a server named WOLFHOUND:

sp_helpserver WOLFHOUND

name

network_name

status

id

-----------

-------------

--------

------

WOLFHOUND

WOLFHOUND

rpc

2

There are other uses for the information returned by sp_helpserver. For information, see the Microsoft SQL Server Transact-SQL Reference.