Transact-SQL Reference
sp_help_targetserver
Lists all target servers.
Syntax
sp_help_targetserver [ [ @server_name = ] 'server_name' ]
Argument
[@server_name =] 'server_name'
Is the name of the server for which to return information. server_name is nvarchar(30), with a default of NULL.
Return Code Values
0 (success) or 1 (failure)
Result Sets
If server_name is not specified, sp_help_targetserver returns this result set.
| Column name | Data type | Description |
|---|---|---|
| server_id | int | Server identification number. |
| server_name | nvarchar(30) | Server name. |
| location | nvarchar(200) | Location of the specified server. |
| time_zone_adjustment | int | Time zone adjustment, in hours, from Greenwich mean time (GMT). |
| enlist_date | datetime | Date of the specified server's enlistment. |
| last_poll_date | datetime | Date the server was last polled for jobs. |
| status | int | Status of the specified server. |
| unread_instructions | int | Whether the server has unread instructions. (If all rows have been downloaded, this column is 0.) |
| local_time | datetime | Local date and time on the target server, which is based on the local time on the target server as of the last poll of the master server. |
| Enlisted_by_nt_user | nvarchar(100) | Microsoft® Windows NT® user that enlisted the target server. |
| poll_interval | int | Frequency with which the target server polls the Master SQLServerAgent service in order to download jobs and upload job status. |
Permissions
Permissions to execute this procedure default to the sysadmin fixed server role and the db_owner fixed database role, who can grant permissions to other users.
Examples
This example lists information for all servers, and then only for the LONDON1 target server.
USE msdb
EXEC sp_help_targetserver
EXEC sp_help_targetserver 'LONDON1'