sp_helpserver reports on servers. Without an argument, sp_helpserver provides information about all the servers listed in sysservers. When you include a server name, sp_helpserver provides information about that server only:
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 installation documentation for your platform.
