sp-help-targetservergroup-transact-sql.md

title	sp_help_targetservergroup (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/09/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_help_targetservergroup_TSQL sp_help_targetservergroup
dev_langs	TSQL
helpviewer_keywords	sp_help_targetservergroup
ms.assetid	ec3a4a68-b591-431c-9518-053ede522d0c
caps.latest.revision	37
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sp_help_targetservergroup (Transact-SQL)

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

Lists all target servers in the specified group. If no group is specified, [!INCLUDEssNoVersion] returns information about all target server groups.

Transact-SQL Syntax Conventions

Syntax

  
sp_help_targetservergroup  
    [ [ @name = ] 'name' ]  

Argument

[ @name= ] 'name'
Is the name of the target server group for which to return information. name is sysname, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name	Data type	Description
servergroup_id	int	Identification number of the server group
name	sysname	Name of the server group

Permissions

Permissions to execute this procedure default to the sysadmin fixed server role.

Examples

A. Listing information for all target server groups

This example lists information for all target server groups.

USE msdb ;  
GO  
  
EXEC dbo.sp_help_targetservergroup ;  
GO  

B. Listing information for a specific target server group

This example lists information for the Servers Maintaining Customer Information target server group.

USE msdb ;  
GO  
  
EXEC dbo.sp_help_targetservergroup   
    N'Servers Maintaining Customer Information' ;  
GO  

See Also

sp_add_targetservergroup (Transact-SQL)
sp_delete_targetservergroup (Transact-SQL)
sp_update_targetservergroup (Transact-SQL)
System Stored Procedures (Transact-SQL)