Transact-SQL Reference
sp_update_targetservergroup
Changes the name of the specified target server group.
Syntax
sp_update_targetservergroup [@name =] 'current_name'
[, [@new_name =] 'new_name']
Arguments
[@name =] 'current_name'
Is the name of the target server group. current_name is sysname, with no default.
[@new_name =] 'new_name'
Is the new name for the target server group. new_name is sysname, with no default.
Return Code Values
0 (success) or 1 (failure)
Permissions
Only members of the sysadmin fixed server role can execute sp_update_targetservergroup.
Remarks
sp_update_targetservergroup must be run from the msdb database.
Examples
This example updates the target server group of Weekly Bakups to Weekly Backups.
USE msdb
EXEC sp_update_targetservergroup 'Weekly Bakups', 'Weekly Backups'