The system procedure sp_helpserver displays information about servers. When it is used without an argument, it provides information about all the servers listed in sysservers. You can specify a particular server to receive information about that server. The syntax is:
sp_helpserver [server]
For example, to display information about the GATEWAY server, execute:
sp_helpserver GATEWAY