sp_update_targetservergroup (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Changes the name of the specified target server group.

Topic link icon 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)