Reports information about a particular remote server or about all remote servers.
sp_helpserver [server]
is the name of the remote server about which you want information.
Displays information about the remote server GATEWAY:
sp_helpserver GATEWAY
Displays information about the local Backup Server:
sp_helpserver SYB_BACKUP
name network_name status id ---------- -------------- ------------------------------------ --- SYB_BACKUP SYB_BACKUP timeouts, no net password encryption 1
Displays information about all the remote servers known to the local server:
sp_helpserver
sp_helpserver reports information about all servers in master.dbo.sysservers or about a particular remote server, when server is specified.
When Component Integration Services is installed, sp_helpserver lists the server class for each server.
Any user can execute sp_helpserver.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
System procedures sp_addserver, sp_dropserver, sp_helpremotelogin, sp_serveroption
Copyright © 2005. Sybase Inc. All rights reserved. |