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.
sp_helpserver [server_name]
where
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.
Execute permission defaults to the public group.