sp_helpserver reports on servers. Without an argument, it provides information about all the servers listed in sysservers. When you include a server name, it provides information about that server only. The syntax is:
sp_helpserver [server]
sp_helpserver checks for both srvname and srvnetname in the master..sysremotelogins table.
For operating-system-specific information about setting up remote servers, see the the installation documentation for your platform.
