sp_helpserver (version 6.5)

Provides the server name, the server's network name, the server's replication status, and the server's identification number. dsn or fallback are possible return values for status.

For additional syntax information for sp_helpserver, see the Microsoft SQL Server Transact-SQL Reference.

Syntax

sp_helpserver [server_name]

where

server_name
Specifies the server for which to display information. When no server_name is supplied, provides information about all servers of both types stored in master.dbo.sysservers.

Remarks

This procedure returns the server name, network name, status, and ID. Status can be:

dist Distribution server
dpub Remote publisher to this distribution server
dsn DSN server
fallback Fallback server
pub Publication server
rpc Remote server
sub Subscription server

A server can have more than one status.

This procedure is useful if you have access to a server as a DSN through ODBC.

Permission

Execute permission defaults to the public group.