Export (0) Print
Expand All
Expand Minimize

sp_update_targetservergroup

SQL Server 2000

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'

See Also

sp_add_targetservergroup

sp_delete_targetservergroup

sp_help_targetservergroup

System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft