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.