() — Sybase SQL Server 4.0

  1                       Version 4.0 -- 1/15/89           sp_helpserver
  ______________________________________________________________________

  NAME:  sp_helpserver

  FUNCTION:
       Reports information about remote server or all remote servers.

  SYNTAX:
       sp_helpserver [server]

  EXAMPLES:
       1)  sp_helpserver GATEWAY

       Displays information about the GATEWAY server.







  sp_helpserver           Version 4.0 -- 1/15/89                       2
  ______________________________________________________________________

       2)  sp_helpserver

       Displays information about all the servers known to the local server.


  PARAMETERS:
       server -  is the name of the server about which information is to
           be  displayed.  Omitting this optional parameter results in a
           report about all servers.

  COMMENTS:

       o Executing sp_helpserver reports on the  specified  server  when
         server  is  given,  or  on all servers in master.dbo.sysservers
         when no parameter is supplied.




  3                       Version 4.0 -- 1/15/89           sp_helpserver
  ______________________________________________________________________

  MESSAGES:
       The specified server isn't listed in master.dbo.sysservers.   Run
           the  procedure  without the server parameter to see a list of
           all the servers.

  PERMISSIONS:
       Execute permission to public.

  TABLES USED:
       master.dbo.sysservers, master.dbo.spt_values

  SEE ALSO:
       sp_addserver, sp_dropserver, sp_serveroption, sp_helpremotelogin
Museum
