sp-help-targetserver-transact-sql.md

title	sp_help_targetserver (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_help_targetserver_TSQL sp_help_targetserver
dev_langs	TSQL
helpviewer_keywords	sp_help_targetserver
ms.assetid	f841d3bd-901a-4980-ad0b-1c6eeba3f717
caps.latest.revision	35
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard
ms.workload	Inactive

sp_help_targetserver (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Lists all target servers.

Transact-SQL Syntax Conventions

Syntax

  
sp_help_targetserver   
     [ [ @server_name = ] 'server_name' ]  

Arguments

[ @server_name= ] 'server_name'
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 user that enlisted the target server.
poll_interval	int	Frequency in seconds with which the target server polls the Master SQLServerAgent service in order to download jobs and upload job status.

Permissions

To execute this stored procedure, a user must be a member of the sysadmin fixed server role.

Examples

A. Listing information for all registered target servers

The following example lists information for all registered target servers.

USE msdb ;  
GO  
  
EXEC dbo.sp_help_targetserver ;  
GO  

B. Listing information for a specific target server

The following example lists information for the target server SEATTLE2.

USE msdb ;  
GO  
  
EXEC dbo.sp_help_targetserver N'SEATTLE2' ;  
GO  

See Also

sp_add_targetservergroup (Transact-SQL)
sp_delete_targetserver (Transact-SQL)
sp_delete_targetservergroup (Transact-SQL)
sp_update_targetservergroup (Transact-SQL)
dbo.sysdownloadlist (Transact-SQL)
System Stored Procedures (Transact-SQL)