sp_update_targetservergroup (T-SQL)

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)

Result Sets

None

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'

See Also