sp-add-targetsvrgrp-member-transact-sql.md

title	sp_add_targetsvrgrp_member (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/09/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_add_targetsvrgrp_member sp_add_targetsvrgrp_member_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_add_targetsvrgrp_member
ms.assetid	5021ed5b-acca-4f8b-b9db-18733059c359
author	stevestein
ms.author	sstein

sp_add_targetsvrgrp_member (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Adds the specified target server to the specified target server group.

Transact-SQL Syntax Conventions

Syntax

  
sp_add_targetsvrgrp_member [ @group_name = ] 'group_name' , [ @server_name = ] 'server_name'   

Arguments

[ @group_name = ] 'group_name' The name of the group. group_name is sysname, with no default.

[ @server_name = ] 'server_name' The name of the server that should be added to the specified group. server_name is nvarchar(30), with no default.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

A target server can be a member of more than one target server group.

Permissions

Only members of the sysadmin fixed server role can execute this procedure.

Examples

The following example adds the group Servers Maintaining Customer Information and adds the LONDON1 server to that group.

USE msdb ;  
GO  
  
EXEC dbo.sp_add_targetsvrgrp_member  
   @group_name = N'Servers Maintaining Customer Information',  
   @server_name = N'LONDON1' ;  
GO  

See Also

sp_delete_targetsvrgrp_member (Transact-SQL)
System Stored Procedures (Transact-SQL)