Reports information about a particular remote or replication server, or about all servers of both types. Provides the server name, the network name of the server, the replication status of the server, the identification number of the server, and the collation name. Also provides time-out values for connecting to, or queries against, linked servers.
Is the server about which information is reported. When server is not specified, reports about all servers in master.sys.servers. server is sysname, with a default of NULL.
[ @optname = ] 'option'
Is the option describing the server. option is varchar(35), with a default of NULL, and must be one of these values.
Affects the Distributed Query execution against linked servers. If this option is set to true,
Enables and disables a linked server for distributed query access.
Remote Publisher to this Distributor.
lazy schema validation
Skips schema checking of remote tables at the beginning of the query.
Enables RPC from the specified server.
Enables RPC to the specified server.
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
use remote collation
Uses the collation of a remote column instead of that of the local server.
[ @show_topology = ] 'show_topology'
Is the relationship of the specified server to other servers. show_topology is varchar(1), with a default of NULL. If show_topology is not equal to t or is NULL, sp_helpserver returns columns listed in the Result Sets section. If show_topology is equal to t, in addition to the columns listed in the Result Sets, sp_helpserver also returns topx and topy information.