For SQL Server 6.5 information, see sp_helpserver in What's New for SQL Server 6.5.
Reports information about a particular remote or replication server or about all servers of both types.
sp_helpserver [server_name]
where
This system stored procedure returns the server's name, network name, status, and ID. Status can be:
dist | Distribution server |
dpub | Combination publisher/subscriber |
pub | Publication server |
rpc | Remote server |
sub | Subscription server |
A server can have more than one status.
Execute permissions defaults to the public group.
master.dbo.sp_values, master.dbo.sysservers
This example displays information about all servers (sp_helpserver with no parameters).
sp_helpserver
This example displays all information about the sales server.
sp_helpserver sales