sp-update-targetservergroup-transact-sql.md

title	sp_update_targetservergroup (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_update_targetservergroup_TSQL sp_update_targetservergroup
dev_langs	TSQL
helpviewer_keywords	sp_update_targetservergroup
ms.assetid	4ac65ed6-e07e-40e4-a282-13bfd92dfa41
caps.latest.revision	31
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sp_update_targetservergroup (Transact-SQL)

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

Changes the name of the specified target server group.

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

Transact-SQL Syntax Conventions

Syntax

  
sp_update_targetservergroup  
     [@name =] 'current_name' ,  
     [@new_name =] 'new_name'  

Arguments

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

[ @new_name =] 'new_name'
The new name for the target server group. new_name is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)

Permissions

To run this stored procedure, users must be granted the sysadmin fixed server role.

Remarks

sp_update_targetservergroup must be run from the msdb database.

Examples

The following example changes the name of the target server group Servers Processing Customer Orders to Local Servers Processing Customer Orders.

USE msdb ;  
GO  
  
EXEC dbo.sp_update_targetservergroup  
    @name = N'Servers Processing Customer Orders',  
    @new_name = N'Local Servers Processing Customer Orders' ;  
GO  

See Also

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