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:

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.